-
Conditional formatting in calendar view
I currently have conditional formatting set up in grid view where the text in a particular column is a certain color depending on the value. Is there a way that this same conditional formatting will apply and be visible when I switch to calendar view? Currently, all the info is the same color when switching from grid view…
-
Calendar View
Hi, When I click on calendar view, I get some weird calendars (something like 1899)? How do I make 2023 the default calendar when I open calendar view?
-
Users having issues with accessing published sheets
HI I have had several users reach out to me indicating they are no longer able to access a published sheet. They have been able to access in the past but now they are not. Nothing has changed with these published. Yesterday for one user, I deleted their account and re-added. Once he accepted the invitation, he was able to…
-
Reloading the same form
Hi, I'm setting up a form which reloads after every submission but there's no option to get out of the form without closing it completely. You can just close the form and it seems to capture everything, however that isn't very intuitive for the form user. Is there a way to choose "complete another" or "final submission"…
-
Cell formatting issue
Hi, I seem to be having an issue with cell formatting. I have set up formatting for cells to turn red/green, I then added a rule to make the whole row white if the date in the date column is in the future... For some reason although the white row rule is at the top it is not applying this above the others? Thanks, Will.
-
Intermediate license
Hi everyone, I wanted to know if you planned to add intermediate license. Indeed, if somebody just want to modifie a title of a column or a question in a form, this person must have a complete license. I thinks it could be very intersting if you create two type of license one for modifie and one for creation and modifie.…
-
Extracting data from bulk sheets
Hi all!! I don't know if this is possible - we use Smartsheet for all our clients, so over 1000 people complete a type of exam in their own sheet, and have a linked dashboard (both in theor own folder). We look at their pie chart widget in their dashboard to track how far through their assessment they are. Basically in my…
-
Orderable Charts
Good morning, I've done several searches here but now I'm going in circles. I have a sheet with records of usage of certain scripts we have. Each row has the user name, the script they used and the time they saved by using each script. My goal is to create a dashboard with two bar charts: user name vs total time savings…
-
Why is my automation not triggering?
I have two columns I would like to run in an automation, one contains a check box and the other contains a drop-down menu of text values. I am trying to run an automation in which when I check a checkbox in one cell, it updates the "Status" cell in the same row to 'Complete'. The automation either doesn't trigger or takes…
-
Remove Reply in Smartsheet Button from Comment Notification
Hello, I use the Comments of the Sheet to communicate with other people regarding the Requests we have in the Sheet. The comment notification that is sent automatically when a user has mentioned another user in a comment is very useful. However, I would like to remove the "Reply in Smartsheet" button that is shown at the…