-
Require all approvals received before setting status to Approved
I have this successfully working column formula in Overall Approval Status: =IF(COUNTIF([Approval - Kashif]@row:[Approval - Adam]@row, "Declined") > 0, "Declined", IF(COUNTIF([Approval - Kashif]@row:[Approval - Adam]@row, "Approved") > 0, "Approved", IF([TEAM A - Approval Requested]@row = 1, "Submitted", ""))) From AI: The…
-
Count tasks due in the next 14 days with multiple status from another sheet
I am trying to reference another sheet and count the number of tasks that meet the following criteria: Hieraracy@row should be Child Status@row should be Not Started or In Progress Finish@row (date) is in he next 14 days (from today) I was successfully able to do the reverse (completed in the last 14 days) by using this:…
-
Formula to Check Restricted items in a Multi List Drop Down
I have a field "Failure Summary" in a sheet that has a drop down list that allows multiple selections. I want to write a formula that will check mark those specific items in the drop down list, if a corresponding column@row has "NO" as the value in that field. Is it possible to write a formula to do this?
-
Dynamic Formula to links multiple sheet based on Sheet Name
Dear Team, I have multiple folders (Individual Project) in workspace which has multiple sheets in each project folder. Is there any dynamic way or formula to link the individual sheets data (example Total Budget and Actual Cost) based on the Sheet name (Main Sheet contains a Columns Projects Name which has each Project…
-
How to view tasks assigned to me? NOT using reports
I am setting up Smartsheets for my small consulting company. We have sheets for each project, and sheets for company-wide meetings, and almost sheet has a column to assign a task to a specific person. I have seen the option to make reports but reports are not helpful at all. I need a solution that does not involve reports.…
-
How to use the data in the Predecessor Column as a variable.
Im trying to use the number inside of the predecessor column to call out the location of the row to get information from that row. =VLOOKUP([Predecessors]@row, {Predecessors}, {column x}, false) =INDEX([column x], MATCH([Predecessors]@row, [Row])) none of these seem to work. Is there a way to call the predecessor column as…
-
Calculating Time Worked for Employees
I have a start time and end time in my smartsheet but need to calculate hours worked. Has anyone used a formula before to do this? if so can you pass along?
-
Is it Possible to Automatically Update a Dropdown Based on Booking Counts?
Hi there, I need some input on setting up my workflow and I'm unsure if it's possible. I have a scheduling sign-up sheet where people sign up by date, and each date has a limited number of spots. I want the date option in the drop-down to be removed once the count of bookings for that date reaches "0." Screenshot below for…
-
Duplication detection after initial row of information
I have reviewed some of the other solutions for duplicate detetion but am finding those formulas are not tailored to my situation. I need to keep the initial row and hide the duplicates. In the formula I'm using, I need the church or organization row with the oldest date to remain unhidden, while the remaining rows with…
-
I want to create an equation based on complex matrix
I am trying to change the status of a column, base on the top five impact levels ( Not Significant, Minor, Moderate, Major and severe) based on the conditions below. Would I have to nest in 25 equations, or does smartsheets have a simpler way of reaching this solution?
