-
Parent cell - Status symbol total
Hi there, How can the parent cell (circled in blue) automatically reflect the correct color/symbol concerning the tasks below? When I say automatically, I refer to do it by default, not me selecting the symbol all the time. Can this be done with a formula, and if so, which formula? Thanks in advance M
-
COUNTIFS Formula
I am fairly new to working with formulas. I have a Project Status column that contains several values with "In Progress". For example, In Progress - Scoping, In Progress - Development, etc. I would like to count all the instances of any variation of In Progress. I have tried working with HAS and CONTAINS and recently came…
-
How to update a formula to automatically populate for the prior Monday to a cell date
Hi! I have the following formula from the discussion board (shoutout to Craig) for automatically populating the Monday prior to a certain date: =IF(ISDATE(Date@row), IF(WEEKDAY(Date@row) = 1, Date@row - 6, Date@row - WEEKDAY(Date@row) + 2)) What do I need to change on this to have it calculate the FRIDAY prior? I'm sure…
-
IF & AVG functions
I'm looking to create a report of averages and actuals to help predict spending. I'd like to create a function that does the following: Displays the average spend for YTD if today's date is less than the 1st of current month Displays the actual spend for the month if today's date is greater than the 1st I'm starting with,…
-
Need per user formulas for counting cells
I am trying to create 2 formulas to get information for a dashboard. The first is a formula that looks at RYGB as well as assigned user and counts all cells if they match both criteria. I tried this but can't seem to get it to work: =IF([Assigned To]@row = "Clark Everson") AND(=COUNTIF(RYG:RYG, "blue") The second is a bit…
-
rollup formulas
I have personnel sending out emails. I want to track how many total emails each person has sent in a given city they put a checkbox after each email has sent. I would like a formula that would total the checked boxes from each person. is that a countif? countifs? thanks, SGF
-
COUNTIFS w/ new multi select dropdown
Hey all, I'm looking for a way to use the COUNTIFS function on a column that is Dropdown (Multi-Select). I've seen a few tips about using "Find" but when referencing another column on a different sheet, keep returning an error. For this example, I'm trying to count department names. Thanks in advance!
-
Find last occurrence in one column return value from another
I am having difficulties trying to do something that I am able to do in Excel. I want to find the last instance of a value in one column and return the value from another column in the same row if there is a value in that column. Here is an example: Name Number Peter 4 Paul 6 Mark 7 Peter 15 Peter 10 Paul Peter Peter I…
-
If function for priority
Hello, I am working on trying to come up with an IF function for priority. An example would be IF the cell is high priority (Red exclamation point) then the number 1 is given, but if it is medium priority (Yellow line) 2, or if low priority (Blue down arrow) 3 is given. These flag images can be changed if needed, it was…
-
I am trying to get the parent row date to auto update to next cleaning interval date
Hi All, We are trying to capture our equipment cleaning logs using Smartsheet. I have created a sheet with hierarchy levels for each piece of equipment and all the cleaning dates needed for the year. What I would like to do is have the date in the parent row be the next date due, based on whether or not the Last cleaned…
