I have a project plan that I am working on that requires certain tasks to be completed weekly, monthly, or quarterly. Is there a formula or automation that can be used to make a task recurring?
Add a Occurrence column to your dataset to indicate weekly, monthly, quarterly, etc. (make this a dropdown to prevent typos)
Add a Resource column [identity type] that includes the person(s) responsible for the task
1 workflow would be created for each Occurrence type:
Trigger: When date is reached
Conditions: Where 'Occurrence' field is equal to Weekly / Monthly / Quarterly
Alert someone: Send to contacts in a cell
Select Resource column
Include custom message and sheet columns to be included in the message
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
I need a formula that will count the day that a row is "Open" but stop counting the days once its "Closed" both instances need to display the count. Here is a formula I was trying to use. Thanks =IF([Date Closed]@row > 0, ([Date Closed]@row - [Date Opened]@row), TODAY() - [Date Opened]@row)
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.