-
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…
-
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…
-
SmartSheet Data to Excel Macro OR Any Alternatives?
Hello, I am new to SmartSheet and have been working on a project. Currently, the data I am working with is entered through a form by users and inputted from there into a SmartSheet. The data I am working with is free-text text boxes (so things like comments, etc.) and I was tasked with coming up with a way to sort through…
-
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…
-
Percentage of check boxes - Need to exclude blank cells
Hello! I am working on a formula to calculate the percentage of boxes checked. This formula is currently working when I set the range to exclude the blank cells. However, I need to allow space for more rows to be added in the course name column in the future. I would like to make this formula to exclude those blank cells…
-
Finding a value from one sheet on another sheet and transferring cell info onto both
I need help figuring out a formula that will cross reference between two sheets. I have one sheet that stores our open orders and another that tracks our orders undergoing quality assurance. What I need is a formula that takes the order number from the open order sheet and searches for it on the quality assurance sheet,…
-
Smartsheet Automation: Copy and Move Rows Limits
Hello all, this might be long winded, so apologies!!! My situation: I have a Smartsheet currently that holds all information for the current FY24 - Lets call it Sheet A. Coming in October, this information needs to archived off of this sheet to lets say sheet B so then Sheet A is blank and can intake FY25 information. I…
-
How to write COUNTIFS with a NOT element
I have a working formula for looking up an external reference sheet. All the external fields are tagged with an M: =COUNTIFS({ReportM}, "Jul 24 - Oct 24", {ProjectM}, Metric@row) but I now need to exclude a third criterion {ThemeM}, "History" I tried adding it as =COUNTIFS({ReportM}, "Jul 24 - Oct 24", {ProjectM},…