-
Merged: Report Totals Printable
This discussion has been merged.
-
Need help with multiple nested ANDs
I'm pretty new to smartsheets and can't quite get the syntax right for what I'm trying to get at. This is what I'm trying to achieve in plain language: IF YEAR([Due Date]@row) = YEAR(TODAY()) AND(WEEKNUMBER([Due Date]@row) = 52 AND WEEKNUMBER(TODAY()) = 1) THEN "This Week" ELSE "Not This Week" END Thanks for any help!
-
Contact Formula from Latest Comment Column
Hello all - I'm looking for some formula help. Without getting to deep, I'm looking to develop a formula that can extract the emails from Latest Comment, regardless of their position in the comment, if/when they are added in the latest comment. I currently can move (1) email but not multiple ones. I then put it in a helper…
-
How to total spend by month?
I am new to smart sheet attempting to create a budget tracker and will need to total the spend by month, for now just using actual spend. I tried a formula I saw online and keep receiving unparseable, could be user error though. Attaching a screenshot of the headers I am using and some fake data for testing. I may either…
-
Abbreviate year that is returned using formula (to obtain fiscal year quarter)
Happy new year Smartsheet crew! I'm returning the quarter of my end date using this formula: =IF(MONTH([End Date]@row) <= 3, "Q4", IF(MONTH([End Date]@row) <= 6, "Q1", IF(MONTH([End Date]@row) <= 9, "Q2", "Q3"))) And the Fiscal Year using this: =IF(MONTH([End Date]@row) > 3, YEAR([End Date]@row) + 1, YEAR([End Date]@row))…
-
VLOOKUP - cross referencing two data sources
Hi All, Beginner user here :) I would like to cross reference a member number on a sheet that is generated by a form to a master list on another sheet to see if that member has submitted the form. This will allow me to check who has not sent in a form so I can send a reminder email. I'm thinking using the VLOOKUP formula…
-
COUNTIFS/OR/CONTAINS
Hello all I am trying to create a formula to imitate the following filter login in another sheet i am trying to pull a single figure via a countifs function from 5 different columns if any one of the 5 columns have a yes, that would count as 1 can anyone advise how i can pull this please ? @Paul Newcome @Genevieve P. your…
-
Formula Assistance
Formula Gurus - I need a formula that can be applied as a column formula in my column named Actual Duration (Days). IF the row is a PARENT row, the formula should return the sum of its children rows. For NON-PARENT rows, the formula should calculate the days between the Act. Start and Act. Finish columns. IF there is an…
-
Formula returning "invalid column value", but it looks correct.
I used the AI formula generator in Smartsheets and I'm still getting an invalid column value error. I can't figure out why because there is data in the column. If the IMP/DISC column displays Implementation then I want the value from the Implementation Status Update Date to show. If the IMP/DISC column displays Discovery…
-
Need Help with Task Health Formula
Hi - I'm trying to write a task health formula with the following criteria and am hoping someone can help. Here's what I'd like it to calculate: BLUE (NOT STARTED): If the start date is in the future and if the % complete is 0 GREEN (ON TRACK): If today is less than 50% of the task duration and % complete is more than 50%…