-
COUNTIF Formula for Multiple Statues and Conditions
Hi, I'm struggling to have a working formula that would meet the conditions I am trying to have shown. The 6 statuses are: Not Started, In Progress, Completed, Cancelled, On Hold, Delayed So here's the logic I'm trying to apply: If all children are Not Started, the parent is Not Started If all children are In Progress, the…
-
Today() Function not updating
Has anyone else noticed that the today function is no longer updating consistently when sheets are triggered through either cross sheet references or through an automation that records todays date. I have used these procedures successfully for years but in the recent weeks they have stopped working. I can't go back and…
-
Index Match
Hi there, I need help with creating a formula for using Index Match What I want to formulate: If California is selected from the State column dropdown, I want it to index match and reference another sheet to pull record # based upon email. (Bar Number CA is the same as Record #) Current formula:=IF([State Column]@row =…
-
If Has on multi select with an Index/Match
trying to get this to work.. but failing on correct syntax. =IF(HAS("California", State:State), , IFERROR(INDEX({DS-Record #}, MATCH([WSGR Email]@row, {DS-Email}, 0)), "")), IF(HAS("CA", State:State), "") ultimately, we have a multi-select option on the form, if they select multiple states we want it to look up their bar #…
-
Nested IF/INDEX/COLLECT
Hello, I’m looking to add to an existing formula. The formula below checks if the Country and Instructor Currency match and pulls in the Fee if it does match, or the Converted Fee if it doesn’t match. The formula also matches the Instructor Name, Course and Format match. This has been working great where I have an…
-
Duration as a formula to accommodate resource allocation varience
I have three columns in my schedule sheet. Duration (native column) hours and resource allocation. I would like the Duration to be my hours divided by my resource allocation. So If I plan to put 2 people on a 80 hours project my duration is only 5 days not 10. I tried a formula in my duration column but it doesn't allow…
-
SUMIFS for multiple reference sheets
Hi, I am setting up a metric sheet for a dashboard chart. I am trying to add Revenue for Delivered sessions, Revenue for Expired sessions, and Revenue for Scheduled sessions. The two columns are REVENUE and SESSION STATUS (Delivered, Expired, Scheduled). However, because of the size limitations to Smartsheet sheets, I had…
-
Formula to return the SUM of prices from a cell with multiple values (multiselect column)
Hello! I'm sure someone has encountered this issue before so hopefully there's a work around it. We have a tracker with multiple service requests. We document each request in a very detailed way here. We already have a lot of columns here, so adding more than 2-3 is not an option. From a multi-select column named…
-
Why are most of my months showing up "N/A" when I know there is data?
Why are my metrics showing N/A on mostly all of my months for Long Term Project TCC? Please see formula below Populates only one month:
-
IF/And/Join/Collect
Hi Smartsheets community, I am trying to create a summary field in a sheet that joins all the text from one column that meets these criteria: has a created date less than 20 days old has a label of "decision" in another column OR a star for priority in another column. I have a sheet used to track RAID entries, and…