-
Automation spanning multiple sheets
Current organization: within a single folder, there are about 10 sheets, each for a different project. The same Assignee will be present in multiple sheets. I want an automation that will send a daily email to each Assignee listing all of their open tasks (i.e. start date has been met). I can do this for each individual…
-
Guage Chart or Speedometer Charts
I couldn't find a gauge chart option in Chart widgets, any idea if it is available or any work around? It is strange - as this is very basic chart other apps/ Software provided for their Dash boards. Seems Customization is not an option in Smartsheet, I mean ever Excell can create a gauge chart.
-
Cell Change Alert
Hi, Does anyone know if there is a way to send an alert if the value in a cell changes by more than a certain percentage? So, if I have 100 in a cell (text/number) and the value changes by over 5%, I'd like to be able to send an alert. Thanks, Vince
-
Approval Workflows with Inconsistent Reviewers
Background: I want to make a sheet that can track all of my review/approval requests throughout a project. I would want multiple types of project documents to be reviewed/approved (e.g., change requests, project charters/plans, test cases, etc.) each with their own set of reviewers/approvers. For instance: Project Charter…
-
How do I print a 2 week calendar?
Hello, I am looking for a way I can print the calendar showing a 2 week view per page and not the full month. Has anyone had success?
-
Graphs giving different values
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
-
Generate Document Automation, select 1 of 3 contracts
Hello, one of my workflows includes an automation to generate a contract. It started as 1 type of contract and worked great. I have a check box to "generate contract" and when that is checked, the automation is triggered. Then we created different forms of the contract: we have 1 for veterans, 1 for people that pay in full…
-
Duplicating Rows on purpose
Hello, I'm trying to figure out a way to create multiple entries on a grid with one entry from a form. I thought about creating "duplicate" tables that would simply receive the data from the form and then move it to the destination form. My concern is I would need to have the same number of tables to perform the move…
-
Incorrect Argument
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
-
Help with formula - COUNTIF and ISBLANK
Hello! I'm looking for help with a formula that is on a dashboard metrics sheet that is summarizing some numbers. I took a screenshot of the formula — essentially I'm looking to count all the # of sites in a specific Cohort but I also want to make sure it doesn't count any sites that are marked inactive in the main sheet.…