-
Specific Dates in Columns
Hello, I have a column that users must input a date that their project will attend a specific meeting. This meeting only happens on set days every month, so I am wondering if there is a way to only allow a user to choose/put a specified date in the cell for that meeting. For example, if that meeting happens on August 9th…
-
If / Or with RGYG
Hi All I am trying to write a formula that shows whether a student is competent. Some units have 3 assessments (A, B, C) and some have 4 (A, B, C, D). I am using the Grey ball to show no assessment or N/A (for the units that only have 3 assessments). * 3 assessments - A, B, C = green and D = Grey then the student is CO,…
-
IF AND Formulas - Where am I going wrong
Morning All, I have been trying to work out a formula for a calculation, i am not very good at formulas so i cant see where i have gone wrong, can any one help please? I need the below: If today > actual start date & today is > actual end date & % complete < 100% = Red If today > actual start date & today is < actual end…
-
Sumif / Countif
Hi All, Still new to SmartSheet so help would be appreciated I am trying to sum a column if another column contains specific text "street lighting" I have come to =COUNTIF(Team:Team, "Street Lighting," ([Past Due Date]:[Past Due Date]) but it comes back with Unparseable and I am lost, It's probably something simple that i…
-
Tasks on Track and Off Track Count
Good Afternoon All, The Vice President has decided that for each project plan he wants to know the below information A count of the number of tasks that should be in progress (using start date) A count of the number of tasks that should have started and havn't (using % complete and Start date) A count of the number of…
-
SUMIF Returning $0
I have a "Status" column with dropdown options of "Pending" and "Accepted". I have a second column (CAR Amount) with a dollar amount in each cell. I want to sum the amount of all rows marked "Pending" and then do the same thing with all rows marked "Accepted". I have tried: =SUMIF([Status]1:[Status]64, "Pending", [CAR…
-
Need a How-To: IF [blank addends], blank, IF [values], sum
I'm working with this formula, which gives me [Expected Completion Date]: =[Planned Start Date]1 + [Expected Days Duration]1 Without values in Planned Start or Expected Days, I get #INVALID OPERATION in the Expected Completion. What's the simplest IF/THEN to use that will return a blank in EXPECTED COMPLETION if we haven't…
-
Formulas that work across sheets
With no pivot table functionality & Reports having no aggregating functionality, and Sights having on wigdet capable of aggregating data we struggle to summarise or aggregate our data up. We could create a summary sheets that count/sum our data in other sheets IF Smartsheet allowed formulas across sheets (which it…
-
COUNTIF with WIldcards
I have a survey sheet where all columns start with specifc chars: D-, I-, O-. Each contains differing descriptions following the "-". I want to create a sum of all "D-", "I-", etc. disregarding the descriptive text following the "-". I am using COUNTIF([Column1]:[Column X],="D-*") with no luck. Always returns "0" unless I…
-
Formula to include a specific range and all new entries
Hi, I have a formula as per below and I want it to start calculating from row 6 to the bottom and include all new entries. Can you please help me? =SUMIF([1 - BT]6:[1 - BT]44, "KS", [1 - # of BT]6:[1 - # of BT]44)
