-
Can you automatically populate the Owners list?
I have two columns: Task Team & Task Owner(s) Is it possible to automatically populate the Task Owner(s) column based on the value entered in the Task Team column? Example: If Task Team = Technical, then Task Owner(s) = Bob If Task Team = Training, then Task Owner(s) = Kathy and John
-
Rich Text formatting in cells
I would love to see rich text formatting be available in cells on a sheet. We have several reports where we rely on certain words in a cell to be a different color than the other words in a cell (quickly showing variable options or redlining changed content if only a word or two has been altered). Currently, we are only…
-
Formula - Count IFS
Hello, i am having trouble with a calculation I am trying to use. The formula is : =COUNTIFS({Original Due Date}, >=[Column22]@row, {Original Due Date}, <=[Column23]@row, {Days for Deviation Closure}, >30, {Days for Deviation Closure}, <61) The calculation does not give me an error (all results return as 0, however, if I…
-
Hot key for Expand and Collapse Row
As Business Analyst, I'm frustrated when working with large projects that I cannot expand and collapse with a hot key. I find it cumbersome to use a mouse to click the + or - on a row of nested rows to expand or collapse the nested rows. Ideally, I'd like keyboard/hotkey functionality tied to the expand and collapse…
-
Whats the formula to find todays date between a range of dates to provide a value?
i need a formula to find todays date between the start date and end date, then provide the current sprint
-
Dashboards into decks
We take screenshots of dashboards to put in decks; this is necessary for different use cases where we need to share dashboard in different ways and can't just use the live/dashboard version. This becomes pixelated and does not look sharp. Would like way to export dashboard graphics to other platforms in a way that…
-
Enhancement Request: Timed Cycle Through Dashboards
is this possible?
-
LOGIN User name and Password required everytime
Smartsheets needs to repair this issue, please! Every time you log out or just X out of the smartsheest/Chrome browser it requires user name & password every time. I believe this has happened since they introduced the desktop app.
-
Max and index match function
Hi all, i have a sheet where Trailers are logged in multiple time throughout the day and what they had in them such as a PO number or a load number in a separate sheet i want to type in the Trailer number and i want it to pull the recent entry date of the trailer and the Load number / po that came in that trailer. How can…
-
Issues with "Record a Date" Automation
Hi all, Any idea why this automation isn't recording a date? We have a formula that's designed to return a value of "Reorder" whenever the inventory for that products dips below a certain threshold. The formula is working, but it's not being recognized as a trigger with the attached automation. Any advice would be much…