-
Different working day schedules
So I thought building two schedules and linking them would help me get around have two different working days within one schedule. The majority of the workers in my schedule work 10 hr days 7 days a week and then the others work a 5 day 8 hour work week. What I have been doing is keeping track of my 5 day work week tasks…
-
Comments - Keep important ones on top
Hello, Are we able to lock comments on rows or sheets do that they stay to the top?
-
Automation for expiring dates
Hello, I'm trying to create an automation for a coloum of expiring dates. Each row is associated with a different email, so when the date for their insurance is expiring in two week I would like to sent out an automatic notification to that email address associated with that row. Is this possible?
-
Date in form has changed from English to American
Afternoon, Is this a bug, one of our forms requires the user to put date of registration in, this afternoon it has flipped from the English version DD/MM/YYYY to the American MM/DD/YYYY....I need to change this back asap - can anyone advise on the reason this has happened. Regards,
-
Dashboard Auto-Refresh rate
Hi, we are displaying dashboard on TV on open space hall. To keep TV login secure, we are using account without licence, and this user is Viewer only. But when we tried to set up Auto-Refresh rate to 1 minute (it is important to see dashboard with live data) it displays error message. However I can set this up as licenced…
-
Overwriting Lines?!?
Is anybody having issues with people overwriting each other in their shared sheets? We have (3) users utilizing the same sheet and adding in lines at any given time and we started to experience some refreshing issues. It just happened again today as a line I created 2 hours ago was overwritten by another user AFTER they…
-
Filtering/Slicing in Dashbaords
Hello SmartSheets Team, I am a little new to SmartSheets, but I have successfully built a dashboard with all the data I would like. However, I can't seem to find any functionality that allows me to filter/slice the data in the dashboard view, say to specific users or anything like that (for example, I can see total sales…
-
Formula to show a workspace name and the sheet name
Hi, is there any cell formula to show 1. the workspace name 2. the sheet name
-
Copy of My Response Email
Hi, there. I have a couple of questions regarding the email that is sent when a user chooses "send me a copy of my responses" when filling out a form. 1. The email is coming through with a high importance flag. Is this standard? Is there a way to change this? 2. The email sender is forms@smartsheet.com. Is there any way to…
-
Check entire checkbox column for a check
Hi all, As shown in the screenshot below, I'm trying to scan the entire MR column for a check mark and if the box is checked, I would like to return the value in the Tower Status column. For example, in the case of the screenshot, I would like to return the value, "status 2". Only one box will be checked in the entire…
