I’m running an onboarding scenario where I ask sales to give me a potential startdate of a new project this data is pushed through a webhook to another scenario where i want to implement values in a certain cell based on the startdate
for example if a project has a startdate in may 2025 (05/2025) i want to input a value into the column which respresents may
e.g. i have a new client “Client X” who is added on line 5 and the start date is 5/2025 so in cell H5 it should say “start”.
Can someone help 
Hi @Bryan_Verlinden,
I would use 2 dedicated calculation cells in your sheet, for example A1 and A2 in another sheet :
Write the date from webhook in A1 (Make : update a cell)
Write a sheet formula in B1 to find the column number matching with the date in row 1 [with index(match())]
Read the B1 cell (Make : get a cell) to read the column number;
Make: add a row to add the “Client X” in column A
Make: update a cell (with R1C1 notation directly, first 1 being row number from addrow module, and second 1 being the value you got from B1 get a cell)
Hope it helps,
kudrachaa
1 Like
Worked perfectly - instead of a normal index match, worked with a SUBSTITUTE(ADDRESS(1, MATCH(B2, Sheet2!1:1, 0), 4), “1”, “”). Gives the column letter immediately but does the same thing. Thanks!
