-
How to show/convert days to weeks on project plan
Hello All, duration column circled in blue is automated as per the project setting circled in red is all manual I know weeks cant be determined from entering dates so i entered weeks manually in actual duration column and it has set the dates, but the roll up is in days is there a formula I can use on another column to…
-
Replace user
When an unlicensed user has left the company and is replaced by another one, how do I easily replace that person's name by another one throughout several sheets in several workspaces?
-
UNIQUE Return Formula
Hi I am trying to return a unique word from a Column on my sheet "FinData" I want to pull unique projects names from the column and create a list of the project names I have tried a variety of index/match ect and just can seem to get it right EG: =INDEX({Project Name}, MATCH(false, ISNOTBLANK({Project Name}), 0))
-
Display All unique Level 1 Hierarchy from one smartsheet to another
Hi I have equipment as a column in EQ needs smartsheet and it is a level 1 when expanded I have all the data below it for that piece of equipment. I am trying to make a calculations sheet that will only show all the types of equipment (level 1) entered onto the calculations sheet. When I go to the calculation sheet it will…
-
IF ERROR function - Help request.
Hi guys, I'm working with the following formula: =IF(MONTH([Start Date]@row) = 2, "February", IF(MONTH([Start Date]@row) = 1, "January", IF(MONTH([Start Date]@row) = 3, "March", IF(MONTH([Start Date]@row) = 4, "April", IF(MONTH([Start Date]@row) = 5, "May", IF(MONTH([Start Date]@row) = 6, "June", IF(MONTH([Start Date]@row)…
-
How to Incorporate OR with a COLLECT Formula
I have the following working formula that I need to modify to look for either two people in the "Resi - Onboarding Specialist" column in addition to meeting the date range. The formula below is working for one application but the next application needs to also include calculating the median if the "Resi - Onboarding…
-
I need to use an IF formula for a helper column
I have a form for users to submit the temperature of units (freezers and refrigerators). There are over a 100 units across multiple buildings, thus having them as dropdown options in one column is not user friendly. Instead I used a column for each unit and established form logic for the appropriate units to appear based…
-
Return the max date looking at multiple criteria
Trying to add the most recent training completion date (column is date/non-restricted) using mulitple criteria, to include: email address, training type ("refresher", or "intensive") and status ("attended") to a designated column (date/non-restricted) on another sheet. The formulas below are pulling the same date into each…
-
Date Formatting from a Formula
Hello, I'm importing dates from an excel sheet that have a time stamp, and I have a formula that removes the time stamp in Smartsheet. This is fine except the date won't convert to 00/00/00 for that column. Does anyone know if there's a way to covert the format? Thanks
-
Hours:Minutes:Seconds reported by consultant at $/hour calculated to the hr/min/sec used
I have a consultant who bills at the hourly rate down to the Hour:Min:Seconds time used. They provide us with Time in this format 1:13:51. How do I take that time and multiply it by the rate to give correct cost per time in USD?