-
Changing the color of a widget based on number in metric sheet
Is it possible to change the color of the number in a widget based on what it shows in a metric sheet? Maybe using conditional formatting somehow? Maybe it is not possible at all? I will include pictures below. Basically, I would like the number in the metric sheet to be green if it is 0, yellow if 1, and red if 2. Is this…
-
keeping multiple assigned people in selected order
Hello there :) Is it possible to assign multiple persons in a cell, but in the order of my choosing? as of now, it orders them alphabetically, but this does not help much, as it cannot provide clarity over the aspect of who initiates the task, who is second, third... Having separate columns is not a good solution,…
-
Update Request Form Field - Dropdown contact
We have an update request where the user selects a contact from the drop down list. Once submitted, if you go to the sheet, it is only listing the person's name in the cell rather than their contact. I have confirmed that their name and email are listed correctly in the sheet's drop down list and have tried deleting and…
-
IF statements with special characters
I am building a multiple IF statement series to convert names into something that is compatible with a naming convention. I've run across a challenge with some names having special characters and the IF statement is not recognizing a name with special characters. Example convert "HEART & SPINE" to "Heart and Spine 0012345"…
-
How can I calculate total hours by project but not repeat the formula in every row that matches?
Hello, I found a question from 2021 that had been answered with a formula, so I gave that a try for my sheet. It works, but I'm getting the sum on every row that has a matching project ID. How can I just get the sum once for each project so that I can run a report and show these totals? This is the formulas that I used…
-
Recurring Tasks and Automation
I am relatively new to Smartsheet and would like to set up an automation for recurring tasks on the Schedule sheet. One suggestion was to use automations to clear out information if marked as Complete then change the date to the next due date. I would also like to include a notification then to the assigned person. Would…
-
Check Marks refuse to show up in columns.
Hello, I recently saw they were having an issue with check marks properly showing up in columns. All my blue check marks have turned into empty cells. When you hover over the cell the blue check shows than leaves once you move out. I have deleted all cashe and history. I have tried on MAC and HP and every type of browser.…
-
Publish sheet so that everyone can view it but only team members can edit
Is it possible to publish a sheet so that everyone can view it but only team members edit? This would be useful because then there would be only one link to share with both viewers and eligible editors. From what i found a major problem with view only links are that a team member has no way to login and edit the sheet. The…
-
Metric Widget on Dashboard not pulling symbol anymore
Hello, I am hoping someone can help me to understand why I am getting an error now with my metric widgets in on a dashboard. Previously I was pulling a sheet summary into a metric widget that would show a "symbol" on the dashboard. Now it is showing an image error symbol and not pulling this through to the dashboard…
-
How can I save a default value for a hidden Contact List?
I am trying to set a default value for a hidden contact list but even after clicking "Save", when I refresh the page and return to edit the form, the default value doesn't save. Screenshot after clicking "Save": Screenshot after refreshing the page: I want to use this field so I can send the same email to 2 different…