-
Referencing formula for other sheets?
Is it possible to build a formula that references other cells/sheets into a new sheet? I am trying to create a sheet that would sum values from another sheet into a new one to build some stats. Because the source sheet is generated using the SmartSheet/JIRA connector rows are automatically and constantly being added, so I…
-
Hyperlinks in Smartsheet
Is it possible to configure the Hyperlink in Smartsheet to open a local program in my computer like what we do normally in Excell ?
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
Report to show all Project Managers without duplicates
Trying to create a simple report that will list all project managers from (3) sheets without duplicates. I can get the report to give me all the project manager names without any issues. The problem I have is it showed duplicate rows of the same project manager. I would be ok with a single project manager name entry with…
-
Autofill Date Column with Conditional Formatting
Hi there, I am trying to set up an approval sheet. I would like my "Due Date Column" to auto fill a date 3 days before the date in my "Date" column only if my "Completed" check box is NOT completed. Can anyone help me with this formula? Thank you
-
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…