-
CountIF Formula Help for Dashboard
See screenshot. I want to create a graph on a dashboard that shows how many total rows on the sheet pertain to Medical, Fire, and/or Police (indicated by checkbox columns on each row). Will I need to create an Agency Name sub row for each Medical, Fire, and/or Police I want to be represented on the graph for the COUNTIF…
-
Customizable Subject Line for Automated Alert
Good Morning Smartsheets Community! I have a stupid question that I am pretty sure I know the answer to, but just in case I wanted to reach out and check. Does anyone know, how customizable is the subject line of an automated alert? For example, below is a screen shot of the automated e-mail that gets sent out when a new…
-
Blank Automation Notifications
Hello, I have a number of automated workflows setup using Dynamic Cell Data in the subject lines and message bodies. This morning I was informed that some received message with blanks were the Dynamic Cell Data should have been. Has anyone experienced this issue before? No columns had been adjusted prior to cell changes.…
-
TRying to collect all projects of a sales person
im trying to pull all the projects of a sales person like in a pivot but these fomulas only pulls at only 1 project. what is the suggested formula? Note: [Project Number Hidden]$20 = Sales Person =VLOOKUP([Project Number Hidden]$20, {Project Management Master SP to PN}, 3) =INDEX(COLLECT({Project Management Master…
-
Dashboard Metrics - Help with Formula
I am trying to set up a formula for a dashboard metric. I have a separate sheet for my metrics. The metrics reference a sheet called “Policies, Procedures, & Guidelines Inventory”. There is one metric that requires referencing conditions in two columns. I was able to set up the formula with one condition, but I can’t…
-
Join Collect output, need help filtering.
I have a formula that is working correctly for how it is written but still isn't providing me the results I want. =JOIN(COLLECT({Purchasing Log_FM0052 Rev. B Range 3}, {Purchasing Log_FM0052 Rev. B Range 1}, [MIS P/N]@row, {Purchasing Log_FM0052 Rev. B Range 4}, ="Open"), ", ") ="Open" is pulling from a field with four…
-
Select Entire Coloumn in Sheet Summary Formula
This might seem super basic, but I am trying to build a formula in a sheet summary and want to define an entire column as the rane. I know that it should look like [Column Name]:[Column Name] but is there any way to select the whole column to automatically insert that synax into the formula without having to type it out?
-
Automated Alert to Someone Based on Parent Info only - not children
Hello - I need help creating an automated notification. I want someone to be notified when a project status = Complete. I created an automation that works, except I only want it to work in the PARENT rows, not any of the CHILDREN rows. I can't figure it out. Thank you!
-
Searching formula for index/match, searching for matching value on multiple sheets
Hello all, I'm a newbie and am getting stuck trying to find the correct formula to return an ID associated with a person when searching for this person across multiple sheets. I'm familiar with INDEX/MATCH, but am having trouble figuring out what function to combine with it. Example: Homer has a record in Sheet A…
-
Average IF or Avg(Collect) to obtain the average of multiple scoring values
Hello Everyone... I am a bit new to Smartsheet and trying to find my way. I have an issue where I have an external reference to a 2nd sheet to collect a point total for how thoroughly some questions are being answered. I have up to 8 different people who will be scoring the responses and these scores will be tied to the…
