I am trying to return a value to a cell, based on a date condition at the top of the column. For example, if there were 52 columns of the "week dates" in a year. The parameter for the return value is IF the date condition falls between a start date and finish date. I have been able to do this when I convert all dates to a…
Hello I have been using Smartsheet for quite a while however I am really stuck on this formula. I've been searching and reading and none of the things I have found work and I'm thinking it should be this hard. I'm obviously missing something. I have 2 columns with scores in them (that had been calculated using another…
I'm trying to automate the RYG circles according to several columns of a Smartsheet grid for project management purposes. The logic is below (I've also attached a visualization of the logic): IF [Proposed Product Launch Date] <TODAY, "Gray" IF [Proposed Product Launch Date] >=TODAY AND [Deviation from Proposed Launch Date]…
Hello, I am trying to write a formula to count executed leases for 2019 and 2020. I do not have a lot of experience writing long formulas but basically the logic is count if there is a date in the Lease Signed field AND if grand opening is between 1/1/19 to 12/31/19 or 1/1/2020 to 12/31/2020. Can anyone provide some…
Hello, Is there an easy way to send an automated reminder based on an approval request? We automate approvals from some of our Smartsheets and would love for a reminder to be sent x days later if the approval status is still "Submitted". I can't find where I can build a reminder based on the status change plus a number of…
I have the following columns and need to return the value of something from a date through the end of the year. 1. Est Mo Contract Count - A number 2. Ave admin - Dollar Amount 3. Estimated Value - 1 x 2 4. Start Date - Start Date that 1 actually goes into effect 5. Weighted Value - Sum of 4 through end of the current year…
Hey guys, I have read several posts with several workarounds for calculating a value between a Start Time and an End Time where the input and result need to be in HH:MM. I have an idea and a beginning: 1. I created two System Columns. [Start Time] as 'Created (Date)' and [End Time] as 'Modified (Date).' 2. I created a…
Hi, Are you able to help? I have a column named "snag" which is a red flag check box, then another column named "PM" with drop down name initials I need a formula that calculates, when a Red flag is raised and PM name is "XYZ" the result is = ZZ number of projects I'm going wrong somewhere and can't get it right, see…
I am trying to write an IF statements that allows me to set either an up, sideways or down arrow based on the the difference between two dates. I have found many example and have tried to reverse engineer them however I am not having any luck Basically if the two date fields when subtracted = a number less then or = 7 then…
Good morning, I am using Smartsheet to track swim time which has a format of minutes:seconds:fractionalseconds (i.e. 5:00.50). I would like to see if anyone has a solution for a couple of issues I am seeing: 1. I would like to use the MIN function to look across multiple cells (swim meets) and pull the minimum for the…
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I want to use Project Name and Resource name as a criteria to pull hours worked into a different sheet. Please help.
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…
i need a formula to find todays date between the start date and end date, then provide the current sprint