-
IF INDEX MATCH w/ DATE & CHECKBOX
Hi, I am trying to capture the date a treatment was done on a separate sheet. As you can see by the screenshot, I just want to index and capture the DATE OF VISIT when the checkbox is checked under RE-EXAM and match to the BARCODE. I have tried several IF(INDEX(MATCH formulas but none of them have worked. Your help is muchβ¦
-
Retain last used number after moving rows out with Auto Generate Document number w levels
Hello folks, I sure could use some help. I have a working PRF Document numbering system for where Parent row and Children are a family of numbers. (see example below) (*many thanks to the folks who posted this solution!) PROBLEM: When I move rows of completed PRF's from above rows off the sheet (because it gets quite longβ¦
-
If formula with nested AND, OR, NOT ISBLANK within
Not sure what I did wrong as when I'm reading through the formulat i wrote it seems correct, but I'm not getting the correct color value. Essentially I need: if the status is "Not Started" OR "In Process" OR blank AND the "End Date" is not blank OR is less than today's date, turn red. If the "End Date" is blank=Gray",β¦
-
Stacked and Unstacked Bar Chart
I'd like to create a Bar chart that is both stacked and unstacked. The chart I'm trying to build is for forecasting cash. We have multiple categories of incoming cash by week and multiple categories of outgoing cash by week. For each week I'd like to have one stacked column for incoming cash next to one stacked column forβ¦
-
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β¦