-
Workflow Management
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
-
Forms
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 filled out a new row is created the formulas aren’t being placed in the appropriate cells so the notifications for leads would…
-
Formula for Duplicates
I am looking for a formula that does not count the duplicates so that it can count unchecked boxes. Does anyone know of one?
-
Latest Discussion comment viewed in a cell
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 the latest comment is without switching views.
-
SUMIFS - Contains value in cell from another sheet
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 want the formula to sum the total invoices paid, in the "REO Vendor Invoicing (3)" dashboard, of jobs that contain a cell…
-
Project Dashboard Generator
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 in one location and have all the reports reference that project number to pull data from their respective sources, then…
-
Linking Sheets
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 pull the Project Name column data, but I cannot for the life of me figure out how to automate it, where if I add a project…
-
Salesforce ServiceCloud Users/Connections
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 there who would be willing to chat with us and give us feedback on our use cases? Even if you don't use ServiceCloud but know…
-
Nested IF, AND, OR/AND
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 higher than 70%, Safety observations over 30). I created a column [MEASUREMENT] stating "Higher than" or "Lower than", a…
-
Avgw based on a criteria
I'd like to apply different weightings based on a staff members role on the staff sheet. I have a weightings sheet that defines the weighting for each task per role. I can't work out how to write an if statement that says, if the staff role (staff sheet) matches the staff role (weightings sheet), then use this row of…
