Sign in to join the conversation:
Hi,
is it possible to have formulas added automaticaly to in every row in the column? e.g If someone adds new row or delete it by accident.
Yes, it is. Look here: https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I'm looking to create a formula that will count the number of overdue tasks. This is based on the "assigned to", "status" and "due date". My current formula is =COUNTIFS({[Sheet Name]}, <TODAY(), {[Sheet Name]}, ="[Assigned To]"). However, this is pulling tasks that are due in the past, but are completed.
In the above image the green is the parent line, where some are calculating the child line %'s below, however in the lower half of the image it's not doing so. Any suggestions please? Thanks!
We run our project delivery sheets in Smartsheet and are required to present them to clients on a monthly basis so they can see status updates and timelines. When we print to PDF, it reduces everything on A3 to tiny print and the client has to increase the view to see what is written. One of our clients uses another…
