Sign in to join the conversation:
Any tips on getting this formula from excel working in smartsheets?
=EDATE(A2,VLOOKUP(MONTH(A2),'Data Table'!$B$3:$C$15,2,0))
Hi,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I have a Control Center program that creates a project management sheet for each new project. In the Intake Sheet we have a contact column "Project Manager" where Control Center pre-populates the project manager's contact name in every row, of the project, where the project manager oversees the task associated with that…
I am looking for a formula that will look at this table and pull the hours per week based on 2 criteria – group and week. Right now, I have the tables separated so that I can use a vlookup formula. But that means I have to have 5 different formulas, 1 for each group. =IFERROR(VLOOKUP(ROUND(($[First Receive]@row - $[Week 1…
Hi, I am needing to create a column that will display the correct month based off a date in another column. My columns are below. I am not certain on which formula to use. Thanks for the assistance!
