-
Conditional formatting based on column date
Hello, I am trying to change the status of an action item to Red or Green based on the date it was completed. The logic in my head, reads as follows (if (Completed>EndDate)) -> RED, else Green but when using condition formatting , its not allowing me to select the EndDate column, instead its asking me to put a specific…
-
Moved rows not appearing on selected sheet
I have a saved workflow that triggers when rows are added or changed and when 'Done' is checked, that selected row is to move to another sheet. For some reason the rows have disappeared and not appear on the selected smartsheet. Can someone help with this? Thanks in advance.
-
Sort in sheets
Good afternoon, Oh, how I long for sorts within a Sheet to be saved like it is in reports!! We have a set sort we need, but it gets undone throughout the day by other users. When will this be implemented to save the time of having to constantly resort? Also, having more than three sort options for a sheet would be beyond…
-
Alert automation stopped working - anyone else experience this?
This automation has stopped working for me. (April 6, 2022) Is anyone else experiencing the Alert automation not sending out alerts? Any ideas how I can kickstart it back into action? (I've opened a request with Smartsheet as well)
-
What happened to automatic scheduled reports of changes to a smartsheet?
I used to keep team mates up to date by using the feature to send a weekly report of any changes to my smartsheet project, but I don't see the option any longer to create reports like this. Was this feature removed?
-
Task Status
I am evaluating Smartsheet against MS Project. In MS Project I have a custom field that tells me task status automatically. In progress and on track means the start date is today or earlier, the end date has not passed and the % complete is proportional to elapsed time. Behind schedule is same but % complete is less than…
-
Cell Value Changing back to "Sent" on its own through smartsheet automation
I currently have a sheet that is changing a cell value to "sent" at 8AM everyday which trigger another workflow and sends out an overdue alert. I looked through all my workflows and i cant find one where it should be changing a value at 8AM. Any ideas as to why this could be happening? Thanks! Kathy
-
how to change the default allocation %??
Hello, I would like to change the default allocation % to 0% rather than the default auto-fill 100%. Is there any way to achieve this??? Look forward a quick reply. thanks.
-
Way to automate check boxes in a form?
Hello, I have a form with multiple check boxes for people to check off based on which option they want (they can select multiple or just one). I want to be able to have an ALL OF THE ABOVE option but want to find a way so that when a user of the form checks ALL OF THE ABOVE, it will automatically generate all the other…
-
Sharing Your Sheet
Good Morning, I'm very new to smartsheet. I have been going through some tutorials and making some sheets etc. From what I understand you can share your sheet with others even if they are not a paid subscriber. Are they able to make changes to the sheet as long as you give them permission to? This is my main purpose of…