-
"Smartsheet Formula Examples" template cell references issues
The "Smartsheet Formula Examples" template, while very helpful, appears to have a variety of issues with cell references that have been moved over time. Somewhere around row 26 things start to get weird. Is this only on my copy of this sheet? I did delete it from my workspace and reload it to see if it would be fixed, but…
-
Return a sum using using sumifs and dates
My objective is to return a sum of all 'Work Hours' that are in a department (Wire in this example), that fall within a date range of the 'END' date that Smartsheet is reporting.. This formula returns a value, but I've checked manually, and I've determined the value is incorrect. I've exported a filtered view of the sheet,…
-
RYGG balls based off of the date
Hi there! I am working to automate the RYGG balls and its like I can get parts of the formula to work separately but not all together. I added a Past Due column to use to try to refer to that indicator to get the formula to be a little less complicated. The goal is: If Due Date is blank =then no balls or "" If the Due Date…
-
Multi Select Dropdown Witih Criteria pulled from Another Smartsheet
Hello! I am attempting to create a Smartsheet form. When a user completes the form they need to identify every account that will be impacted by the project associated with that form. How can we include a multi-select filed in the form, with which all accounts to select from are included in a separate smartsheet list? is it…
-
User Administration Invite vs. Shared
I am getting errors when attempting to invite a user to smartsheets. The error "xxxyyyzzz@xmail.com" is currently a licensed user in Smartsheet. To add them to your account, grant them a license" I do not want to grant them a license of ours if they are already licensed and we have very limited licenses. We did this with…
-
I want sync a field across multiple sheet, being able to edit it from any of those sheets
Use case. 4 sheets Intake Sheet, Prioritization sheet, Resource sheet & Overall Status Sheet When a project is requested it is automatically added to the "Intake" sheet through the form. Status field is New. When we agree that the team will work on it - we add the Unique identifier to the "Prioritization" sheet and the…
-
How do I use IF formula to change a colour based on a percentage column?
I have a status column with red, yellow and green. I'm needing a formula to change these colours when the percentage complete column gets below a certain percentage. i.e. 1-50% Red 51%-99% Yellow 100% Green
-
Automated Workflows and Charting Are Very Powerful
My Smartsheet application is going on six years old now and was in need of a rewrite after years of incremental improvements that used newly available capabilities in Smartsheet and as the needs of my company changed. My application basically takes project timekeeping data from an internally developed app via the…
-
Use Metric Widget to Show User Selectable Single Row
I want to be able to display the data from a single row on a dashboard (see image), but I want the user to be able to select which row to display from the rows available to them. Can this be done with a metric widget or some other method? tx DJ
-
Count all of the Level 1 Parent rows in a SmartSheet
In the document's Summary Sheet, I want to count all of the Level 1 parent tasks in the Sheet itself. In the example above, the answer is 2.