-
Countifs to Find Duplicates
I am trying to find if there are multiple requests for a bucket truck within a single day. I am getting an incorrect argument set when I try this formula, but I cannot figure out what is wrong with it. =COUNTIFS([Date Resource(s) Needed]:[Date Resource(s) Needed], [Date Resource(s) Needed]@row, [Bucket Type]@row, "55'…
-
How can I export Schedule view?
I am looking to create a custom dashboard that does not seem feasible with the current filtering options available in People or Project view under Schedule. Is there a way to export resource bookings in Schedule?
-
Different Settings in Same Project Sheet
Is it possible, by formula or settings to have within the same project sheet, some tasks & sub-tasks that will need to use a 7-day work week (no weekends, no holidays) and also some tasks (and sub tasks) that will need to utilize the 5-day work week and holidays? To clarify, all of this is in the same sheet for a single…
-
Smartsheet not uploading MS Project schedule accurately
Is there are reason Smartsheet will have different start and end dates, as well as apparently adding removing random tasks?
-
Reservations/Scheduling & WAITLISTING
First time posting, and I'm not sure if I'm doing this correctly, or if this is the right place, please have patience. I have a workspace, with a form, and a sheet (although it's definitely not NEAR as optimal or helpful as it should be), along with a few other sheets/resources (past appointments, contact lists, specific…
-
Appointment Number Generation
I am building a Project Management system to deal with a high flow of scheduling. Currently I have the system built using the auto number column type, however when it came to creating a copy of the row I quickly found that the system will not update that value when it is passed out to a separate grid and cleared of…
-
Data shuttle is not running on time
Hello, We have multiple data shuttles setup to run at 5:00 am UTC and to repeat every 15 minutes with an end time of 4:00 am UTC. We effectively need these shuttles to be running every 15 minutes nonstop. For whatever reason the shuttles will stop running for no apparent reason and will not restart without us manually…
-
from google to smartsheet
My team has been using Google Sheets as a colorful scheduling tool. They love it, and it has served them well for many years. I am not trying to reinvent the wheel. I am trying to stop utilizing Google since we live in Smartsheet. Any help to recreate this in Smartsheet would be beneficial. Cells are colored differently…
-
Bah Humbug! No holidays for you. (None of our projects have holidays)
I need a sanity check. I just found out I know nothing about how holidays function in Smartsheet. My education came about I was making a "simple company calendar" for our intranet. And now I am facing some problematic implications. Please confirm my understanding below. Situation: We use control center to provision…
-
#DATE EXPECTED Error
I am trying to create an email reminder automation on one of our project schedules. We want the alert to go out 10 days before the line is set to be due (Finish Date Column). I created a date column to generate the reminder date (for the automation to use) by subtracting 10d from the finish date column. Some lines in this…
