-
Previous, Current, and Next Weeks with New Year
Hi All, I'm wondering if there is a more efficient way to identify the previous week, current week, and future weeks when the year changes to the new year. I am using the following formula: =IF(AND(YEAR([Change Start Date]@row) = YEAR(TODAY(30)), WEEKNUMBER([Change Start Date]@row) - WEEKNUMBER(TODAY()) = -49), "Tree…
-
Monthly Sequence
Hi - uploaded an excel sheet to Smartsheet that is not compatible with a formula. The formula in excel was: =EDATE([Column9]14,1) which calculated the next month (1/1/2024, 2/1/2024, etc.) what is the smartsheet version of this? I can't drag the dates because it is a row and not column of dates.
-
Trouble with Auto Number column type. Shows up different in cell.
Hello, I am trying to use the auto number system and am having a little trouble. You can see in the first image that I have programed it and the preview is pictured as well. First cell should populate as C001. From the second image, you can see how it populates in the cell. It is stating with the number C011 instead. Can…
-
conditional totals per column
Hi all Hoping I can find some help on this formula, Trying to figure out how to create sum totals of PO value column at the top of each of the first 3 columns (FERG JOB #, FVLV#, JOB SHOP #) if information is present in those cells. contingent on any of the items in the drop down list from PO/SDR down being selected. Any…
-
Need help finishing formula for status
I want to Turn the status to Yellow if [Done?] is unchecked and the field [Server must be 100% Cutover to New Box by:] is less than 13 days away from today if not then green. So this works: =IF(AND([Done?]@row = 0, [Server must be 100% Cutover to New Box by:]@row - TODAY() < 13), "Yellow", "Green") BUT, I want to add to…
-
How can I track when a ticket is past its number of SLA days??
Hello, thank you in advance with helping with this question! Please see below: Situation: My team uses a Smartsheet intake form to take work requests from other teams. This populates into a sheet with the needed information to move tickets to different status' (ex: New Request, Active, Backlog, Triage Required). All of…
-
IF OR Formula Help!
Hello! I'm trying to put together a formula in the Posted To field pictured below, to return a result of either "Internal" or "External." The formula I'm using is below. =IF(OR([Portal Status]@row = "Posted", [ATS Posted]@row = "internal"), "Internal", "External") This formula returns an "Internal" result but I can't quite…
-
Average number of day formula
I have these two columns "Date Created" and "Date Closed". I need to write a formula that looks at all 1000+ rows of data and produces an average amount of days it takes to close a row of data. The formula will be in my calculations sheet. So, I'll be referencing this data. Should I use the "averageifs"? I really…
-
Can you call a sheet summary formula inside another sheet summary formula?
I have 6 sheet summary formulas. They are a sum of loads in that year over the 6 years those formulas represent. What im trying to do is calculate the percent changed year over year but it seems I cant call those formula returns into another sheet summary formula.
-
Add number of months to effective date to output End Date
output End Date based on Contract Term (months) less 1 day. so basically add the number of months to the Effective Date, less one day to get the End Date.
