-
Can Smartsheet Handle Shifts (Different Working Hours) for Scheduling?
Looking at using smartsheet as a scheduling tool for our project (heavy construction) as it is more mobile friendly than say an MS Project or P6, and the gantt charts actually work as opposed to airtable which has a great interface but their timeline "block" is garbage. We work 2 or more shifts with our crews, so I need to…
-
Calendar App Add-on - New Event
Hello, Currently, I have the add new event function enabled for the calendar app. The calendar is pulling from a sheet which has a column where I am using a formula to format the event info in a way where it can be easily read by our team. Is there currently a work around to "hide" the formula column from being accessible…
-
Advanced Calendar App - Contact List
Hello, Just wanted to get some feedback regarding changing "contact list" fields in the Advanced Calendar Application. When i am editing "contact list" fields (such as a users name) directly in the advanced Calendar App, then press the "update" button so the information is updated in the related Smartsheets, i am getting…
-
Do not show parent row in calendar view
Hi, Is there a way to set up hierarchy with several tasks and different dates, and not have the parent row's date, which ranges from the first to the last date in the tasks below it, show in calendar view? I want just the children rows to show, so to keep my calendar cleaner. Thanks for any help
-
Use triggers from Smartsheet?
Working on a new workflow. Today's workflow is manual and based on emails. I'd like to use the webform to collect the required data (done) and then, based on specific conditions in the sheet fields trigger actions in other system - from generating email to open a service ticket etc. I watched the movie of the docusign -…
-
Help With Dates If Certain Criteria are met
Hi I am trying to work out how to Auto work out overdue date See attached i would like to get my Site Audit Complete column when marked "yes" to calculate the "Site Audit HN Dead Line" column's date continually move my overdue date to the current date each day until column marked Site "Audit approved" is marked Yes Is…
-
Editing rows from Calendar or Gantt view of report not working
When I attempt to edit rows by double-clicking a row in Calendar view or Gantt view of a Report, I receive the error-message attached. I have searched the forums and guides, and cannot see anywhere why this should not be possible. It occurs with all my reports in both Gantt view and Calendar view. Re-login does not help.…
-
Conditional formatting in Calendar View
Is there a way to extend conditional formatting to Calendar View? I did notice that if you click on an individual item you can change to desired color. But my project extends over 2FYs and has over 1000 items, so individual formatting is not an option. Thank you.
-
Dropdown choices for date fields
Hi I've noticed within a form when I preview an entry for a date, I can drop-down the year and month to select, but within a sheet I have to click through to get future dates! Any chance that feature could be added to sheets themselves, so I don't drive my co-workers crazy clicking through with my mouse? Thanks
-
Is there a way to collapse the rows in a Gantt chart?
I'm trying to take a spreadsheet and present it in a way that has one row for each category of item, and then multiple cells across that row to represent the emails sent in that category. This is a calendar of sorts. Each category would be associated with a color. (That's the part I have figured out.) I saw Smartsheet's…
