Formulas
Discussion List
- 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…
- Hello, I have determined a way to identify the day of the week via a helper column formula with additional helper columns for the current week. What I want is a way to differentiate the current week f…
- I'm using the following formula to extract the name of the month (e.g., "May" if there is a "5") but keep getting an "Invalid Data" error. =IF(MONTH([SLA Month]@row) = 1, "January", IF(MONTH([SLA Mont…
- Hello All! I am having difficulty copying formulas from one sheet to the next- I keep getting "UNPARSEABLE". I have tried copying/pasting in multiple ways, no luck. Details: Formulas look like =COUNTI…
- A would like a Check Box Cell to be flagged if the following conditions are met: Column "EDI Error Type" = X AND Column "Error Details" has a duplicate value. *The columns considered are both TEXT and…