Hi to all,
I need to add a % Planned to my plan. I used a formula but it didn't work.
Attached you have a screenshot of my plan with the formula and the dates columns.
Thanks for your advice!!
Adelina
Hi Adelena. The primary issue I see with your formula is how you are referencing the column names in it. And that you are referencing any row numbers. When referencing a column name with spaces always wrap your column name in brackets like this... [End Date]
You also need to either reference a specific row number after the column name or use smartsheets @row trick to reference the current row. It should looks like this... [End Date]3 --- which will reference row 3. OR [End Date]@row to reference the current row you are in.
Regarding your formula it should look something more like this...
=Round(IF(Today() < [Start Date]@row, 0, IF(...
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
