-
If a value from Column A is found in Column B, can the occurrence be shown as "true".
Hello, I am looking for the easiest formula to help show when a value from Column A shows up in Column B. If it is possible, I do not want to enter each value found in Column A in a formula, as these values are actively changing. (Note: The list "Column A" is also extensive so manually entering each Active Project would be…
-
No Drop Down entry for the week
I am looking for a formula to indicate if there are no entries of an item in a drop down menu within a particular week of the year. Below is a brief rundown of what I have accomplished, and what I desire. I am looking to create a report or dashboard to reflect if an inspection on a particular device has been completed for…
-
Reset Value to 0, No negative numbers
Is it possible to have a number go down the 0, but not have it have a negative value? I'll share my sheets to illustrate. So this is my current sheet. I am running into an issue where people are having a negative total (picking up a ton of OT shifts) and they accumulate a big negative total value, so when they do no-calls,…
-
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…