-
Help with a date / Harvey ball formula
Hi - Smartsheet Community, I'm trying to setup a similar formula but using a date column. I have a column titled Revision Date. I would like to add a column titled Status for the Harvey balls (red, yellow and green) to indicate the following: If revision date is 365 days older than current calendar date display a red…
-
What is the syntax to reference another sheet when using formulas?
I want to use add up costs in an AMOUNT column when the value in the CATEGORY column is SHOES and this display this in a Summary Order sheet. Can someone tell me what is wrong with the syntax of this formula: =SUMIFS({REFERENCE SHEET}, AMOUNT:AMOUNT, CATEGORY:CATEGORY, "Shoes") I've already tried the Learning Center notes,…
-
Calculate totals of two categories within a date range?
I want to display a stacked bar graph in a widget that shows the total amount by month in the "Awarded or Expected Award Date" column broken out into "Funded" and "Submitted". I've included a screenshot of what I'm attempting to do. I found this formula in another discussion thread and tried to adapt but I know it's…
-
Count if there is a blank in another column
I am looking for a formula that will count how many times Alex's name shows up in the "assigned to" column but only if the "complete date" column is empty. Is this possible? Thank you!
-
Not sure how to write formula correctly, not even sure this is a SUMIFS
Hello, Apologies for yet another basic question, but I'm having troubles wrapping my head around how to get a formula to behave a certain way. I'm still working on a PTO manager tool (requests PTO, automated approvals, and auto calculations on PTO Balance, etc...). I have 3 total grids (Submission grid, Track grid, and…
-
Lookup/CountIF Formulas for Multi-Select ranges
Hello, We are referencing another sheet and are wanting to know how many times the word "SNAP" appears in the multi-select cells within a row. Right now, this is what we have, but it won't work. We have tried multiple different formulas as well and cannot seem to find anything to count the number of time "SNAP" shows up in…
-
Days Remaining from a Date
Hello! I'm trying to calculate how many days until the Start Date. I used the following formula: =[Start Date]6 - TODAY() What am I missing? The date column is a date type and the formula column is text/number. Thanks!
-
Divide by Zero Message and IFERROR formula
I am getting a Divide by Zero Message when putting in this formula. It is correct because there are no items that fit this criteria to average. =AVG(COLLECT({Credit Granting Article Tracker Compliance}, {Credit Granting Article Tracker Month Completed}, "2", {Credit Granting Article Tracker Major?}, "No")) I attempted to…
-
import and working with an extensive audit questionnaire in Smartsheet
Hi together, we want to import an extensive questionnaire based on an excel sheet and set the questions to At the moment it looks like the attached example 😃: question 1 / note / percentage / notes question 2 question 3 if we use the form in Smartsheet it will only show the headings, not the questions how can we rotate the…
-
Variance Between 2 Dates (Weekdays Only)
Does anyone have a variance Formula between 2 dates that only counts the weekdays and not the weekends? Here is my Current Formula which Counts All 7 Days: =IF(ISBLANK([Finish Date (Actual)]@row), "", IF(AND(ISBLANK([Finish Date (Planned)]@row), ISDATE([Finish Date (Actual)]@row)), "Start Date Missing", IF([Finish Date…
