-
Gantt Chart
Hi everyone, The Smart sheet is very good for short term projects. For a long term project that spans across more than ten years, is there a way to download a entire Gantt chart? Thanks, Liping
-
How to automate RYG balls using two different column values.
I am attempting to automate the RYG balls using two different columns, the End Date and % Complete columns. The logic is as follows: 1. If the end date is greater than today, the RYG ball = Green IF([End date]2 > TODAY(), "Green" 2. If the % complete is greater than .99, the RYG ball = Green IF([% Complete]2 > .99, "Green"…
-
Please move "Refresh" to the toolbar, and give me a keyboard shortcut.
I would really like to see "Refresh" added to the toolbar. I think a lot of other people would too. Synchronizing changes with other collaborators in near-real-time relies on hitting refresh repeatedly. It's hidden behind a drop-down. Getting new users to refresh (or save) consistently as a matter of best practice has it's…
-
We need Two Cells to Trigger a final cell location
We need When Med4 Quiz is checked and Med4 E Learning is checked, then All Complete needs to automatically check. I have tried =IF(AND([Med4 Quiz]3 < 0, [Med4 E Learning]3 < 0), 1, 0) ...but this is not working for me. Any help with this would be greatly appreciated!
-
Formula to Ignore a N/A if selected from a dropdown, and not break the rest of the formula
I need to add another scenario to one of y formulas, If one of the departments does not have to approve a certain type of change, they will choose N/A from the drop-down. So I will need the Approval Status column to IGNORE the N/A in that row. So if only 3 people needed to approve it choosing then the non approvers choose…
-
Editing Alerts & Notifications - how do I get rules to fire on existing entries
Hi All, Basically I want to know how I can re-fire alerts and notifications that failed due to errors and have been subsequently edited. Example described below We are testing a new smartsheet using alerts and notifications and a multi step approval process based on thresholds. We submitted multiple Smartsheet forms today…
-
Combining IF/IF AND Statements
Hello! I cannot seem to figure out how to put together two working IF and IF(AND...) statements. Thank you for any direction on how to accomplish. Sandy If I put "IF(AND..." in front of all the IF statements, only my first two statements work. The rest are ignored. If I remove the "(AND..." from only the first two…
