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
Hi there! Can anyone kindly please help me with this - I'm new to SmartSheets and having trouble working out formulas… In one column I have dates that Volunteers started volunteering with our company. The second column I used the following formula to get the number of years that it totals: =YEAR(TODAY()) - YEAR([Vol Start…
I am trying to find the right formula to use in the scenario if a cell in the row is yes, then it sums cells in the same row to create a total. threshold totalscore1 totalscore2 totalscore3 Final score yes 46 10 9 this would pull a total for the 3 total score cells in the row no 15 75 12 this cell would not total because…
I can't quite get the filter to align with my intent. I'm either pulling every status when I want to exclude "Complete" tasks or I can't get parent rows for my project schedule. I want the attached report to do the following for ease of presentation past due AND upcoming activities. Status is one of Not Started or In…
