-
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…
-
Merged: Please allow access to create formulas from reports
This discussion has been merged.
-
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%…
-
Add Summary Value from Sub Tasks
Hi all, I have a project tracker that has been created from a project template then manipulated. The template was pre-programmed to calculate/populate the summary value for the Preparer % Complete column but I would like the Reviewer % Complete column to have a Summary Value as well. Is this possible? Thanks in advance!