-
Conversations — but with groups?
My org used to use the “Send” or “Send Update Request” option from the fly-out menu on each row quite frequently. That feature is now only available to licensed users, I believe, as Smartsheet moves people to use conversations in the comments instead. See:…
-
Countif on Checkbox column type
Hi, I am trying to get the % of tasks complete. The column is a checkbox type. This allows me to get the number as long as all columns are 1 (checked) or 0 (unchecked) =ROUND(100 * (COUNTIFS(ES2:ES36, 1) / COUNT(ES2:ES36))) + "%" I need to add a Count if ES2:ES36 contains only 1 or 0, so if the column is set to N/A then…
-
If with dropdown list
I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, country dropdown list will show JP, SG, IN If chose Region AMER, country dropdown list will…
-
Multiple choice option?
Good afternoon, A question was asked of me today if there is multiple choice column in development. We use the drop-down list column, but one that allows you to choose multiple entries would be fantastic. Blessings, Loann
-
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…
-
Update request comments
Update requests are great, however none of the comments get stored within Smartsheet but only get sent as a part of an email. This way discussions get lost that should remain part of the row it is about. Copying and pasting these discussions is just double work. Can we please get away to ad them to tow discussions?
-
Prioritize/sort rows (possible feature request)
It is possible to drag 'n drop rows to change their order, but if you order by some column this "index order" is lost. I need some way to prioritize rows, with the most important at the top. I can do this by adding a column of type number, and manually enter the index for each row, but this is rather cumbersome. What I…
-
Summarise Tasks into single cell
Hi there Smartsheet Community! I have been a smartsheet user for a few years now but this is my first post with the community (so i'll try my very best to describe my issue) I use two different sheets for planning in my company, which is currently manually updated. I am hoping to link these sheets together so that…
-
Can't build an alert - formula-based email not acceptable
Hello community! Anyone have a work-around for this? Here's the situation: I’ve created a vlookup formula in my sheet to obtain an email address from another sheet, and then want to alert someone using the email address result from the formula. When I go to build the condition in the alert (for approval), the alert will…
-
Check Multiple Boxes or Tag Multiple Items Within One Cell?
I know I've asked this in the past like 3 years ago but don't know if there mght have been a feature update or workaround for this yet. Is there a way to check multiple boxes or tag multiple items within a single cell? If I made a dropdown menu of 12 items for example, is there a way to check or select 2 of them for one…
