-
How to build a Training Calendar using SmartSheet that looks like this??
For each day, I need to indicate date, time, location, class, method, class role, trainer. Any chance I can build something like this in SmartSheet. Thank you in advance.
-
Is there a way to Force a Date or Time?
I am trying to have some date fields auto-populate based on some restrictions. Date Columns 2, 3 and 4 would be dependent on Date column 1. For example: An Inspection must always occur at least 2 days after Work Start. If I enter Work Start to be 1/20/2020, I want the Inspection Date to auto-populate to 1/22/2020.…
-
User moved folders and sheets to new folder and that move changed all sheet ownerships
Workspace owner can't be removed if they own sheets or dashboards in the workspace. Please ensure all sheets or DB they own are transferred to another owner. It was alot of sheets - is there no bulk way to correct this? The person that moved all the folders/sheets is not the owner of the sheets.
-
Parent RYB Status Ball - Changing color based on child status RYB ball
Hello, Another request for information! I have a parent status ball that I would like to change color based on the 2 deadline status balls and the dominant completion ball (i.e. row 1 & row 2 - then row 3 being the dominant ball). The colors are as follows: Row 1 & Row 2 - They will be green, yellow or red. Row 3 - This…
-
Flag column based on date & other criteria
I'm trying to figure out how to set up an alert to automatically notify someone if the entry row hasn't met criteria (checkbox) within 5 days. I was thinking about creating a flag column that kicks off an email alert but I can't figure out the flag formula. Here's what I've been trying to play with: If [Created Date] is…
-
How to bid Materials - Construction question needing solution:
Hi Smartsheet, I have the following problem. I am a contractor that has to go around a home and take a materials count on a list of tasks say a door install, window install, etc. Anyways, I am trying to figure out the quickest and best solution to take a materials count for my given tasks and then fill in the info I'll…
-
Formula to auto calculate time difference in hours between two 24hr format times?
I'm looking for a formula to help me calculate the length of hours an individual has worked. Employees enter their "Haul Start Time" and "Haul End Time" manually by picking from a drop down list of times in 24hr format. Once picking their starting time and end time, I would like the third column, "Total Hours", to…
-
Need a visual dashboard/report to display 6 projects, and their upcoming tasks by month,day
Are there Portfolio or Program templates that will display tasks in a gantt chart or horizontal timeline view?
-
SUM totals of VLOOKUP
Looking for help on a formula. I need the Forecast Adjustment column on (A) to add all amounts pulling (B). These should total $13,416.67, however, it it showing as $5,416.67. Please help! How do I change the formula to sum the VLOOKUPS? (A): Forecast Adjustment forumla =IFERROR(VLOOKUP(Category@row, {Table Category_Full…
-
Help with an IF/AND/OR formula
Hello, I am trying to write a formula to return today's date when all of the following are met: Column 1 is not blank Column 2 is not blank Column 3 is either Kangaroo or Platypus If any of these is untrue, then I would like the cell to remain blank. Here is my attempt which returns an incorrect argument error:…
