-
Quiz attempt limits
@Rhonda Keller, SmartU How many times are users allowed to attempt the quizzes at the end of the self paced core path courses? I have had a few people at my company reach out to me stating that they are unable to retake the quizzes.
-
Help with Conditional Formatting
I have to create a report that has conditional formatting onto it. I am not really sure how to work Smartsheet's conditional formatting stuff. The example I was given to create was: "Can color be added based on calendar logic (0-30 days since xxx, for example)" There is an active sheet that we would use to put the…
-
Inserting Symbols and Emojis
Is there a sheet that provides a list of alt codes to insert different symbols and possibly emojis? Thanks
-
Automation: Ability to add a condition to workflow branching off from an unmet condition
Today in automation workflows you can only and conditions to flows that pass previous conditions. It would be helpful to be able to add conditions to the flows that stem from failing previous conditions. Scenario: I want automation to change the status of a task based on it's Target (completion) Date and it's Actual…
-
Sharing with Editors outside our company
Good afternoon! My company works closely with another ambulance service, Company B. Both companies have a Smartsheet Enterprise plan. I have created a workspace that I need members of Company B to edit. Do I need to make them members on my account if they are already members on their account? Or do I just need to add their…
-
Changing series order in stacked bar chart?
I'm trying to show a summary of Projects, by both Branch and Status. I created the stacked bar chart below, but the Status series are in the wrong order and I can't find how to change them. The Status source column is a dropdown with the options in numerical order and the source sheet is sorted the same way, so I can't…
-
Add same file to multiple rows at the same time
I have a list of 131 employees and as the Training Lead, I have to add proof of training to each employee for each training in their separate reports. Currently, I have to do this one-by-one, which obviously takes up a lot of time, especially when I have 30 trainings to do (30x131=3,930 times). It would be very helpful if…
-
Import Excel file through Workspace App
I am trying to import information from an Excel file into an existing Smartsheet. I have a couple of questions. Does it matter which column I designate as the primary column when importing a file? When I try to import, it gives me an error saying the field cannot be more than 50 characters long. I have tried it with both…
-
Showing a timeline (not programme) in a Dashboard
How do I show a timeline as a widget on the dashboard, not the programme breakdown with multiple rows. I am looking to represent a single row that represents the flow from one activity to the next so you can glance at it and see where we are and what's next. Thanks
-
Status to red once the deadline is reached.
Hi everyone, I’m trying to automatically change the Status to red once the deadline is reached. I placed the following formula directly in the Status column: =IF([Ende]@row <= TODAY(), "Red", [Status]@row ) However, I keep getting the error #CIRCULAR REFERENCE. My understanding is that this happens because the formula is…