Discussion List
Help with IF/THEN Network days formula when another field is marked Yes or No
Trying to calculate Network days between two date fields. If one of the dates is blank, then the calculation between the dates uses Today. The formula works great, but in some cases, I won't have dates populated for either field (another field named Comments with selection of Yes or No would be completed). So I want the…
Trying to Sync a Report with Google sheet
What is the best way to sync a report to Google sheet on a daily basis, Zapier cant sync report only Sheets which is disadvantage! Please let me know good services
How to send update requests when a new comment is made for certain users only.
Hello, We use Smartsheet to manage incoming Requests for BusOps and HR requests. I would like to send an update request to our requestors whenever my team makes a comment. However, I do NOT want to send an update request when the initial requestor replies and updates their comment. Is there a way to do this? I feel like I…
Why is blueprint project creation failing to update reporting
I've recently had an issue with summary reporting failing when creating new projects through a blueprint in Control Center. When I run the blueprint to create a new project I get an error at the end that says "Summary Reporting: failed to update cell links to summary report" (first image below). Then, if I select Update…
Sum of Children While Maintaining Column Formula
It would be incredibly helpful to allow for the sum of the children on a parent row, but maintain the column formula.
If And Statement Issue
Smartsheet Community: I am Trying Have My Rag Change to Not Started When The Following Conditions Are Met and Add it to My Existing Formula: IF(AND([Schedule Variance]@row = 0, [Progress Status]@row = "Not Started", "Not Started" I Keep Receiving a Green Instead of Not Started. Her is My Complete Formula Below: =IF([%…
Trying to sum the value of multiselect selections
Hi Smartsheet Community, I have a project built out where as a team finishes a project they can submit a form for that project which will populate a dashboard of graphs to give leadership progress report. They want to be able to select more than one project completed at once so that they can input less forms, I'm right…
If, And, Or in one formula
Hi all I am trying to write a formula but I don't know how to use "OR" to accomplish what I need. Here is an outline. IF Engineering Review Result = "Approved" AND IF Planner Review Result = "Approved", AND IF either (Supplier QA Review Result = "Approved" OR Skip Supplier QA Review is CHECKED), then write "Complete". I…
Cascading Forms
Cascading Form data sets is one of Smartsheet's missing capabilities that I believe would be a game-changer for many alternative providers. Cascading forms are a very effective technique that can be used to compress form data and limit down options in order to narrow a workflow or collect more accurate data. Recent usage…
Limit Sorting Feature
It would be nice if certain users or level could not sort rows. Or if that could be a setting per sheet by the owner. Thanks!