Hi, I have currently formulated the following formula, =IF([% Committed to Date]1 - [Project Status %]1 < 0.25, "Green", IF(AND([% Committed to Date]1 - [Project Status %]1 >= 0.25, [% Committed to Da…
How do I automate the workflow from Person A doing task 1 to Person B doing task 2 and at the same time automate the measure of turnaround time and not being overridden by collaborators? Thanks
I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct. The issue I'm having is when a form is fi…
I would like to request that the most recent comment in the discussion function be able to be mirrored in a cell in that same row. This would allow us to quickly scan a sheet full of data and see what…
Hi All, I want to create a "Total Vendor Paid Amount" column on our "Main Dashboard". This column will need a formula that pulls information from another dashboard called "REO Vendor Invoicing (3)". I…
I am trying to develop a dashboard generator so that I don't have to recreate every report I use in our dashboards each time we have a new project. I would like to be able to select the project number…
Due to the 200 column limit in a sheet, I have had to split my data into multiple sheets, using the project name as the Primary Column for each sheet. I know how to links cells and use IF formula to p…
Hi Smartsheet Community, We're thinking of some use cases for helping Smartsheet users utilize Salesforce ServiceCloud data more effectively and efficiently. Any Salesforce ServiceCloud users out ther…
Hi all, New user here. I have different monthly metrics to comply, some are greater than or lower than a value or percentage (i.e. Open tickets beyond due date is LOWER than 10%, Survey results are hi…