-
COUNTIF in Sheet Summary
I am using this simple formula in a new field in Sheet Summary & I keep getting an "Unparseable" Error. =COUNTIF(RESPONSIBLE ENTITY:RESPONSIBLE ENTITY, "FIRM")
-
count tasks per week number
Hi community, I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year. Here is my formula that calculate 0 every time (at least not an error) : =COUNTIF({6530 - Sulfuric project Schedule Range 5}, WEEKNUMBER({6530 - Sulfuric project…
-
Visual Status bar with dates
Hello - First time posting here! 😁 My question is I am trying to create a formula that will populate the visual status bar and show progress as dates are entered. So if no dates are entered, the Fulfillment Status is "empty." If the Date 1 column has a date, then the Fulfillment Status is now a "Quarter" full and so on…
-
Upcoming free webinar on 3/19: Advanced Formulas!
This webinar is the second in a two-part series focused on formulas. Use advanced formulas to automate information in your sheet and gather insights into the work you manage in Smartsheet. In this webinar, you will learn how to use formulas to: Automate column data, including flags, symbols, and drop-down columns Look up…
-
How can I compare two dates and then add thirty days to whichever date is later?
Hello and first off thank you for your help. I am trying to build a formula in a third column that will allow me to compare two date columns and then add thirty days to which ever date is later. example comparing "Release Date 1" to "Release Date 2" give me whichever date is later plus thirty days. Thank you so much for…
-
Formulas for calculate number of days depending on list of value
Hi there, I need to know if it is feasible to obtain this formula : In a sheet, i can choose several option from a list of value ( checkboxes). If option A is checked, i add 1.5 days for ex. If i choose B, i add 1 day. If i choose A & B, i obtain 2.5. And so one. How can i create that in one formula? Any idea? Many thanks…
-
SUMIF formulas to unify 2 variables
Dear, I would like to ask for help with the following: I am creating a summary sheet to quantify sales by seller as well as by sales area. There are sellers who have the possibility of generating sales in different business areas. Therefore, as you can see in the first image I show this global summary sheet, however, in…
-
Nested if for RYG Balls and qty not working
I am trying to use the RYG balls when noting when a variance has gone over certain amounts: 5000 or less - Green 5000-10000 - Yellow over 10000 - Red I can add grey as my false statement if the coordinator has checked off the completed box. This is the formula I have tried to build so far but I get the Unparseable error. I…
-
Can i remove multi-select from single cell?
Hi folks, Bit of a novice here, i have a challenge for you 😁 We use smartsheet for tracking holiday, sick leave, unpaid leave etc. For 2019/20 we've only had a single-select option for each cell, but this makes it difficult to track when employees work 1/2 a day and also 1/2-day Holiday or 1/2 day unpaid, on the same day.…
-
Best Formula to use to COUNTIFS based on several criteria.
I'm trying to come up with a formula that will return a number based on several criteria. I have a separate sheet that I have a key of allotted days off for each area (Vacation, Personal, Summer Friday, and so on). On that separate sheet, I have an available days based on the Key, minus the formula that i'm trying to…