Formulas
Discussion List
- 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 arr…
- 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 #Incorrec…
- 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…
- 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 i…
- 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 …
- 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…
- 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…
- 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…
- 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…
- 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…