I have created a master sheet for grant invoicing. We have 14 different institutions who received the grant and who will be submitting invoices to the master sheet. I have created a workflow for each institution so that when they submit to the master sheet, that row will be copied to a separate Smartsheet with just the…
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be…
This discussion has been merged.
Hello, I want to set up an automated workflow that triggers when a column is changed to meet a specific criteria. When this trigger is met, will it run the workflow on every row in the table, or only the specific row which the trigger was met? My sheet has hundreds of rows and will likely have rows that change and meet…
Hi all, Every month, we are required to display new data for review. The problem is that it has to be manually done. I have to login the 1st of the month into the data sheet, copy the data of information that we get from a master sheet, create a new column and paste it there which then is linked to a dashboard with a graph…
I am trying to create an IF statement which returns a status based on the status of 6 separate cells. How do I set the status to ignore blanks from those reference cells? For the attached example, the status should be set to "Not Started" based on the columns highlighted in blue.
Is there any way to run an automation or an alert when a file is uploaded to a row? Is there any way to run an automation or alert when a row is missing an attachment? The only work around we've found so far is to put in a check box that must be checked when the file is uploaded, but we are hoping to automate that process…
Hi everyone, Does anyone know how you can keep someone from completing a line item? I have a sheet where I ask for a resolution to an issue and some users are marking the item as complete without providing the details of the resolution. I would like to block them from the cell until data is entered into the resolution…
