-
Help with Formula
I'm working on a formula that will look at cell A if it is = "Milestone" perform this function, if not do this. Have that working. My issue is if the denominator is 0 is produces an error. I would like to add code to return 0 if denominator is 0. The top code is what I need to figure out. The bottom code is what is…
-
Countif reference range
I would like to know when in January an issue was logged. Both my month and Issues are referencing another sheet. I want a count of January issue looking at columns Issue 1 through column Issue 4 (four column range). This works - =COUNTIFS({Month}, "January", {Issue #1}, "002_Bypass Audit") Does not work -…
-
How would you most easily track that a date has changed to a new date that is 'x' different (+,-)?
We are using data shuttle to bring 'start date' in from another system (upon attachment for now; eventually, most recent when it sees it). If the start date changes we have users who want to know if it moved up 10 days, back 3, etc. I can create a hidden column to hold information and calculate - but I can't figure out how…
-
Best Way to compare budget numbers
Hi Communnity, I have been tasked with adding a visual to a dashboard that would compare metrics reported monthly via a form (automated) to a fixed budget amount to show if the entity is on track/over/under etc. What would be the best way to do this - I would want it to automatically populate Thank you for your help!
-
How to bring back averages based on state criteria
I am trying to figure out the best formula to write to accomplish averages per state code. At the bottom of the snippet is where I would like for the averages to live. Example of need: I'd like for all AZ states to bring back averages of SF, Cost per SF, estimating, General Requirements and existing conditions. What type…
-
What does "in the next 45 days" mean in an automated workflow condition?
Hello, I am trying to figure out an automated workflow where the trigger is everyday at 8am and the condition is where a [Date Column] is in the next 45 days. I have many rows in the sheet that each have unique dates and emails to contact when 45 days prior to that date is reached. My question is: does "in the next 45…
-
Help with COUNTIFS
Hello, I am trying to make a smart sheet in the same way as this example template. Form>collector sheet>metrics sheet> dashboard. Basically, I want the end result to be four different graphs tracking monthly results of yes, no, n/a, or other questions. I will include what I have so far and what differs after this example…
-
Change in Report Summary Function
Was there a recent change to the summaries function in a report. In my example below the summary count would only calculate if the box was checked. For example the adj approved count for this section would be 1 and the count for adj rejected would be 4, instead of it counting the total rows for both. Is there a way to…
-
Parent Row Schedule Health functionality
Hello, I have a column formula that is returning random results, mostly on parent rows. The formula is: =IF(Status@row = "Complete", "Green", IF(OR(Status@row = "In Progress", Status@row = "Not Started", Status@row = "On Hold"), IF(ISBLANK([Target End Date]@row), "Red", IF([Target End Date]@row < TODAY(), "Red", IF([Target…
-
Add to INDEX formula to account for blank cells?
I have a mapped column that displays a Contact based on what's inputted in another cell. E.g. Slim J = Slim Julian. Here's the formula: =INDEX({PD - NetSuite Name Mapping USE Range 1}, MATCH([PDS Selected]@row, {Formstack Name}, 0)) However, if the cell is blank, it just assigns the first Contact alphabetically, even…