-
Turn hours (hh:mm) to numeric value (00.00)
Is there a formula to make a column with duration values like 1:30, 2:45, 3:15, etc etc (only ending in either :00, :15, :30, and :45) to 1.5, 2.75, 3.25 hours (again, only ending in .00, .25, .50, and .75, respectively)??? I am VERY new to SmartSheet so, if you could actually explain how to do stuff that would be awesome.…
-
SmartSheet scheduling during non-working days
With Memorial Day approaching, I noticed that I have project work scheduled on 29 May. I checked the project settings, and 05/29/17 is listed in "Non-Working Days (holidays, exceptions). I used the calendar tool to remove and re-add the date, but I still have work scheduled on the 29th. I assume there's a simple solution…
-
"Pretty" PDF export -- Google merge, something else?
Hi all, We’re hoping to be able to export a fairly complicated styled PDF from Smartsheets. Imagine a sheet of movie reviews, where Column A is movie title, B is review, C is reviewer and D is date. Each movie can have multiple rows depending on how many reviews it’s received. We’d like to get a PDF that would look a…
-
Conditional Formatting For 11 Months From a Date
Hi Everyone, Thanks in advance for the help. Here is what I'm trying to accomplish. A service is sold on a specific date. We want a "timer" to start that will highlight the row yellow when it's 2 months from expiring. We want to highlight any row within the 10 month window from start date to be green & dates beyond 365…
-
Creating and editing schedules in Calendar View
Hi all, I am just wondering if there is a way to visually create and edit a schedule in Calendar view. Such as dragging dates and durations like we do with Gantt bars? Darin Schnitzer
-
Alert or notification based on date
I am searching for way to create an notification or a reminder based on a contract's expiration date. I have checked SmartSheet's help data but have found no way to make this happen. Can anyone assist me with how to do this .... all we want to be able to have, is when a contract is within 3 months of its expiration date, a…
-
Grid
Good afternoon , I would like to take off from the first few lines from my sheet the grid not from the total sheet only from the top is their to do that . if so i can make my sheets into a nice looking invoice now i download it into excel and do it from there any ideas ?
-
Linking checkbox to another column
We have a checkbox in our sheet titled "Use Existing". When that box is checked we would like for another column to be added so the person can provide that existing information. If the box is not marked then we don't want that extra column to appear. Is there a way to make this happen? Not sure if there is a formula for…
-
Contact List Cell-Linking?
Does anyone have a work around for cell-linking a contact list column that is used to calculate Resource Management and Conditional Formatting without creating another column? Issue - Person assigned to Task A needs to automatically be assigned to Task Z.
-
formula in all 5000 rows
can i add a formula in one column in all 5000 rows? we have tried but sheet doesn't seem to allow us to add the formula too far beyond the last row of data. any help please?