-
30 minutes time increment round up
Hi, I'm trying to create a column in Smartsheet that shows 30 minutes increment round up. I have a column that shows in minutes for the differences of the start time and end time. =(TIME([end]@row)-TIME([start]@row))*24*60 How can I use ROUND to use in this case for 00:30 increment? Thank you in advance!
-
Need to find all instances of value and return any non-blank cell from another sheet?
Hello Everyone, I'm stumped and need some assistance. What I am trying to do is look for the value in the Cable Number column (Cable Number]@row) on the master sheet in the Cable Number Column on the Update Tracker (Update Tracker Cable}). There will be multiple times this value is in this column but some dates will be…
-
How can I "transpose" multiple columns into one column with multiple rows?
I am looking to convert multiple columns of data into a row per column populated. A bit like "transpose" So as follows: Automation doesn't seem to give me the flexibility to be able to do this. Any ideas? Thanks in advance
-
DropDown list - from another Sheet
hello , i have a huge list to be added in Dropdown, Does Smartsheet have option to pull the Dropdown from another sheet, (similar to excel spreadsheet).? Since the list will be Dynamic, editing the downdrop list everytime is time consuming. thanks Vasanth
-
Countif when multiple values
I have a form that allows users to multi select. I have a metrics sheet that counts the number of times a selection appears, however, it's only working for those that only had a single value selected. Multi-select are NOT being counted. Is there a way to get counts when there are multiple values in the same cell? Here's…
-
IFERROR and NETWORKDAY formula
Hi, I have a source sheet with two date columns: Date of Request and Date of Completion. I am using a summary sheet to create a dashboard and have used this column formula to cross reference the source sheet to find the number of working days between the two dates: =IFERROR(NETWORKDAYS([SourcesheetRange1],…
-
Date Formula that ignores holidays, applies workday and returns rows for yesterday
I am working on a dashboard report that returns records for "yesterday" but "yesterday should ignore Saturdays, Sundays and Holidays. I was able to construct a formula (using a helper column) that looks at the audit date and returns a "1" if the audit date is one day in the past and ignores Saturdays and Sundays…
-
How can I display a summary of all projects that each team member is assigned?
I have a spreadsheet that includes a column "Project Name" (free text, primary column) and then a column "Assigned to this Project" which is a multi-select drop down with 28 names. This list is all members of a team that could potentially be assigned to the project. The number of assignees varies between 3 and 8 team…
-
Get data from another row - matching single value with multible dropdown values
Hi, I have this big sheet (actually two, but I cannot even get it to work in one). I want to return the value in column16, men I can find the value (doesn't have to be a multible select column) - WHEN I can find the single value within the multible-dropdown values. I have searched and tried a lot, but I cannot get it to…
-
Hello I am trying to create a formula that returns a specific date when a dropdown selection is made
class requested start date Jan 13, 2025 - July 14, 2025 Oconomowoc, WI Jan 13, 2025 - July 11, 2025 Huntsville, AL (new site) Feb 10, 2025 - Aug 11, 2025 Amsterdam, NY Mar 24, 2025 - Sept 22, 2025 Fontana, CA Apr 21, 2025 - Oct 20, 2025 Oconomowoc, WI May 13, 2025 - Nov 17, 2025 Huntsville, AL Jun 16, 2025 - Dec 15, 2025…
