-
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.
-
Count occurrences of each variable of a multi-dropdown list
Hi, I'm building a lease administration tool to help negotiate some leases. Each row (lease) has several stages (preliminary, negotiating, at lease, executed lease, open). I want to create a dashboard metric to show how many rows are at a particular stage: Preliminary - 5; Negotiating - 3; At Lease - 7, etc... What would I…
-
Date Range Conflict - Vacation Request Sheet
Hello, I've seen quite a few questions for date range overlap, but couldn't find the solution. The closest I found was the one below, but it was referencing another sheet, not the same sheet I believe, and not sure a simple edit to that formula will make it work for me. Form requests will populate new rows of all time off…
-
Stopwatch Count up & pause functionality Widget
I was wondering if anyone has found an effective stopwatch widget that has the ability the pause. The idea would be to include this within a dashboard so that when groups are testing, they can record a certain time when something occurs. Thanks!
-
Can anybody correct my below if condition ? I need that asap
=IF(OR(AND([UI UX LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)",[DEVELOPMENT LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)"), "FILLING"), IF(AND([UI UX LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)", [DEVELOPMENT LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)",OR([Priority]10 = "HIGH","MEDIUM")), "QUICK…
