-
Exclude weekends from a schedule
I am using this for a project schedule and wanting to exclude weekends permanently. I am using the start date and duration fields for this schedule but need to exclude weekends. For example if a job starts on Wednesday and is a 5 day duration i need this to show as complete on Tuesday (as our trades don't work Sat/Sun)
-
Who inserted a task
Hello, How can I search the Activity Log for a sheet by task name (or parts of it) to determine who inserted a task? I don't want to use row numbers because they change as rows are added or deleted. Thanks.
-
Timecard Approval by WEEK, not by line.
Hi Community! Relatively new to SS, so I am thinking this has a simple solution. We are utilizing the timecard template but need a weekly approval from management. As of now, I can only get approval request to work by row. I do not want the managers to have to approve each row of the timecard... rather, just one approval…
-
Dashboard & Attachments
i'm trying to attach files to my dashboard, but the widget is only giving me the option of attaching a file via 'Box'. is there a way around this? if attaching a file to a regular sheet, I have the option of attaching it from my computer but not the dashboard.
-
One form for multiple sheets
Is it possible to use one Form to fill-in fields in different sheets depending on the option selected. For example, if a user selects Sheet1 then data would be populated in Sheet1, and when user selects Sheet2 data would be populated in Sheet2. All sheets would have the same layout and same required data to be filled-in, I…
-
Updating Old Sheets with Improvements from Newer Sheets
Hi, I have 25 project schedules, some of which are 6 months old. Over those 6 months, I have improved my schedule template over and over. The issue I have now is how to implement these improvements across all of my older templates. For example, I've created conditional formatting with helps with reading my schedule. I'd…
-
Conditions within a Notification
I am building out a notification to send a client updates (daily). One thing the client is asking for is not to see older data (the same stuff over and over). We have an approval date, and if data is more than 3 days old, we want it to fall off the notification. Will the condition in the screenshot below work for what I am…
-
Adjusted Dates Based on the Time a Form is Completed
I am looking to have my automatically set due dates for projects adjust if a request is put in after a certain time of day via the Smartsheet web form. Currently I have a date column where I add a certain number of work days to the timestamp depending on the department that submitted the request that acts as a due date for…
-
Edit all details of recurring emails
Currently only possible to edit the schedule, but would be ideal if we could edit the email text and all other params. You could surely re-use the screen already available for setting up recurring emails?
-
Why can't I change my email to merge accounts?
I mistakenly set up a secondary account and I deleted it so that I could add it to my other account. When I try to add it to my other account, I still get an error message that it's associated with an account. However, I'd already deleted that account! How can I fix this?
