-
Different way to track health
I have a project without a set end date and am being monitored on if I am getting it closer to completion by the % complete field, how can I make a formula that tracks health based on that forward progression so that if my % complete goes up it stays green but if it stays the same for three days it goes to yellow and if it…
-
Nested IF Statements to Determine Priority
Hi everyone, I've written nested IF statements for a Risk Register, looking at Probability and Impact to determine the color. It's been a while since I've done this and I'm obviously rusty. Can someone tell me why the following is unparseable? =IF(AND([Probability]@row = "High”, [Impact]@row = "High”), “Red”,…
-
Is this a bug and if so, how do I mitigate it?
I have a formula to autopopulate a drop-down list field to show one or more items, grouping together a number of related rows in another table. =JOIN(INDEX(DISTINCT(COLLECT({EcoTech Activities Managers}, {Activities PIDs}, =ID@row)), 0), CHAR(10)) Basically collect the names of managers from another table where the key…
-
Dynamic "UNIQUE" Function
Is there any type of function similar to the UNIQUE function in Excel that I can use? I have a Master List on one Sheet (called "QMS Transformations Common List") and I want to use links for the first column on another sheet ("named "QMS Metrics Calculation - Workstreams"). In excel I could use the UNIQUE function, and it…
-
Field Service Management in Smartsheet
Has anyone built a Field Service Management solution in Smartsheet? I need to maintain a database of; store locations technicians, their backup tech and their backup of the backup tech dynamic schedule of availability of said technicians I envision some form of a 'lookup' worksheet where appropriate and relevant data from…
-
How can I auto-populate a formula in a column that is referencing values in another sheet?
I have the formula below that is referencing the Planned Date and Exit Shop Date, but when I drag the formula through the column it doesn't update these dates as well? What I want to do is as I drag the formula down a row I also want the Planned Date and Exit Shop Date to move down a row and not remain static Is this…
-
Hi everyone, is there a way to create Dynamic view on a dashboard but with charts and metrics?
I am making a supplier-facing dashboard and I would like to make a dashboard that displays personalized data, similar to this video. Instead of a Month dropbox it would display supplier names and the data would ideally display specific or personalized info.
-
Metrics Sheet - Restrictions
I cannot for the life of me recall how I set up metrics sheets when I was at my previous company! My circumstance is that I have approx. 150 TDLs (they are like account #s), each with their own sheet in Smartsheet. And I need to count certain columns. They would be like doing a COUNTIF within Excel. The top screenshot is…
-
help with formula IFERROR
Hi I need help with the below formula please as getting errors I would like to count requests submitted from Janaury - December in 2024 and 2025 from a specific region eg, europe, Asia etc
-
HTML functionality to pre-populate forms
I am working on a solution that requires 30 fields (see illustration #1) to be pre-populated with information. The information that is being populated in the fields is also pretty lengthy. I am running into what looks like a character limitation with the final fields (see illustration #2). I have checked the character…