-
Logic Formula: Overall Approval Status
I need help to get this formula right. I have the following scenario but I have no idea how to put the logic into a formula statement. With reference to the following columns, here are the scenario: 1) There are a series of approvals needed from 5 different person 2) If any Approver is "Approval Request Submitted", then…
-
Formula using OR
Can someone help me I keep getting a error message, I know is has to be the OR function. =COUNTIFS({Civic 2021 Range 2}, "RFP Submitted", OR({Civic 2021 Range 4}, "(Stage 3) 3.2 - WON", {Civic 2021 Range 4}, "(Stage 3) 3.3 - LOST"), {Civic 2021 Range 3}, MONTH(@cell) = 1)
-
Nested IF Statements
Hello! SS newbie here. I'm having a hard time with my nested if statements. This is what I am trying to accomplish: If number of items in Past Due Count column is =0, Traffic light is Green, 1=Yellow, 2+=Red, and if Status column (Blue Header row) ="Complete", traffic light is blue. I have this so far: =IF([Past Due…
-
Budget Calculation
I am attempting to calculate the expected spend year to date with a formula that references data in a month column where MONTH(TODAY()) - 1. This works, but when the new year started, it reset all of the expected spend year to date back to 0. Is there away to set a formula that won't =IF(Month6 = "12", SUM([Budget…
-
Quarter formula with some exceptions
Hi Everyone, What I am trying to do is create a formula that looks at two things, the status column to check if the status is not started or draft. If it is either it needs to return a blank. If it is anything else, it needs to check the End Date column and determine what quarter it is and return the appropriate value Q1,…
-
Date Helper Not Helping
I created a driver check in and the shipper wonder if there was a way that they could see when a line last pick up. So I used the a date helper and a time helper to separate the information and I used a separate sheet to pull the information. The date helper formula i am using is: =DATEONLY(Created@row) +…
-
Pulling Approved Data from an Approved Row to a Version
I have talked to Smartsheet Support on this one, but I am under a time crunch, so I was hoping one of you Smartsheet wizards can help me solve the following situation: I have a Tracker sheet that contains requests that go through an review/approval workflow Once approved, there is a 'Latest Approved' column (checkbox) that…
-
Row limits in Reports / Grouping
I am pulling data from 2 different sheets that currently span about 5,000 rows with more to come. When I create a report looking to group the information certain ways it seems that the row limit inside the Report itself is 2,500, is that correct? When the data is grouped, I cannot uncollapse the groupings unless it is…
-
Changing WEEKNUM formula to pull on Sunday's instead of Monday's?
Hello, I have a sheet that acts as a "day tracker." Each row is a new date that tracks specific data in each column. I have a "Week Number" column attached to the "date" column, however the week number populated does not match the week number shown in Outlook calendar and Excel. I think this is because Smartsheets starts…
-
Column Formulas
Hello, I am putting column formulas on a sheet, which I'm excited about. However, we had a top row that had some explanations for users i.e. whether a column was Required, Admin only, and this one that has been super helpful to find people what RYGB stand for rather than having them interpret for themselves. "Status"…
