-
Trying to find values within a dropdown list on another sheet
So I'm trying to to "find" if a value has been submitted in a form where (for ease of form submission) submitters can submit the form for multiple properties. I'm not sure if it's possible without arrays, but seeing if anyone could crack this for me… My formula on the target sheet is this: It's trying to find a hotel code…
-
Formula Issue
So this Formula works =COUNTIF({Skills}, [Primary Column]@row) and this works as well =COUNTIF({Month}, 5) but when i combine them =COUNTIFS({Skills}, [Primary Column]@row, {Month}, 5) I get #IncorrectArgument Set. Why is this?
-
Nested Formula based off dates
Hi, I am trying to make my sheet highlight rows using the Yes, Hold, NO RAG symbols when dates in specific columns are in the past or the row has not been approved. So far I have the below formula but its coming up as unparseable. Can anyone help? I cant see where I'm going wrong. If all dates are in the future it can be…
-
Count formula help
I need to count number of tickets in a few columns, independently, and present the calculations in a metrics sheet to be used later. I need to calculate weekly and monthly numbers. I have tried many iterations of formulas and continue to get errors. Would love your thoughts. =COUNTIF({Week #}:[Week #], ${Week #}:$[Week…
-
"Number of Days Without Incident" Formula
So I need to create a formula that is essentially an automated version of those signs in factories and warehouses that say Number of Days Without Incident: ##. See attached screenshot. I want to know when a team has hit 30 days without an incident. But I want the number to reset if an incident happens. See attached…
-
COUNTIF not working when trying to count with a % in the dropdown options.
I ran into an issue where I am looking for a work around to make the system count a column that has % options in the drop down. So it is a column with these as drop down options. 0%, 3%, 4%, 5%, and 7%. I have tried the normal =COUNTIF(Percentage:Percentage, ="0%") making one for each option, but it always returns as 0. I…
-
How to replace a blank field with contents from another
Hi Community I need help, I have an onboarding form where there are many addresses to be captured. The registered company address is mandatory The main address is optional on the form as only needs to be filled in if different from the registered address. That is great for the form but on the smartsheet I need both filled…
-
Update status in another smartsheet
I have an asset register, each with a unique asset number that also holds a status (In service, out for repair, decommissioned) I also have an asset damages log where an asset is reported as faulty or damaged and is sent for repair. If unrepairable it will then be decommissioned. My question is....... how to I update my…
-
Duration Column with Formula/Dependencies
Hello, Currently, I use a Text/Number column for task duration. I have a workflow set up to change the duration of each task depending on the urgency (either urgent or non-urgent), which is calculated using several weighted questions in the Sheet Summary that populate either a 0 (non-urgent) or 1 (urgent). This setup…
-
Formula Help
I am looking to set up a formula where a status column gets automatically updated to a certain color based on the relationship of the % complete column and the end date column for each row in the plan. Examples of what I am looking for below. If % Complete = 100%, then Status Column = Green If % Complete < 100% and Target…