I would like to automate a RYGG column, assuming that my team is entering there own start and finish dates but due dates will be created by senior staff. Yellow=In progress Red=Overdue Grey = Not star…
I am attempting to consolidate multiple business worksheets, for an aggregate pie chart health status on a dashboard for executive management. See word doc for details Any suggestions to the best app…
Each project sheet has basically an identical structure and each line item is assigned to a specific person/user (Contact list). There are approximately 300 lines per project sheet. Each user has a re…
I have a sheet that uses Hierarchy (on month) and is displayed in descending sort order. I have one calculated field that should be automatically calculated when a new row is added. When the person wh…
Hi all, In the press I read that Smartsheet has released a COVID-19 dashboard for the community - https://www.geekwire.com/2020/smartsheet-q4-revenue-51-78-5m-heres-company-responding-covid-19/ Where …
I don't think this is possible, but thought I'd ask here. I have a situation where I would like to look up a value in another worksheet if the the value in a column adjacent to the lookup contains "DM…
Hello! Creating a sheet to help with Accounts Payable process to external providers. External providers will submit their invoice and payment details into a form that feeds into this sheet. Would like…
Hi all, I'm not very privy with formulas, but am attempting to learn. I'm working on keeping track of square footage production based on "in progress" or "completed" in a manufacturing setting. There …
Here's the setup Sheet 1 Columns: Created [standard] | Name | Form Entry Sheet 2 Columns: Name | Form Entry Display MATCH Name:Name and take the Form Entry with the most recent Created i.e. the newest…
