-
Info box on a dashboard
I would like to place an explanatory field (black box) on a dashboard, which is activated only by a "mouse over" over an infofield (i) (see screenshot example). Does smartsheet provide this functionality? Thanks for any hints.
-
Portfolio Management: Team member part-time availability on Projects
I need the ability to set part-time availability for a team member to specific projects, i.e. working Mon-Wed on Project A and Thu-Fri on Project B. For each project and each team member you could set working days, that would solve this problem. I have a team member in high demand, between two projects an agreement was…
-
Implement the capability to allow records to be moved to a different row and remain intact
This is in reference to the support case #06202095: https://supportportal.smartsheet.com/s/case/5005a00002WaZM4AAN/issue-with-data-insertion-and-moving-them-see-detailed-description Summary of the case I use a plugin called Smartsheet for Jira Connector to sync data between Jira and smartsheet. The issue is that when I…
-
Smartsheet Desktop App Keyboard Shortcuts
Hello, I was wondering if anyone knows whether the Desktop app has extra keyboard shortcuts for "Go Back" and "Go Forward"? For instance, when working on a dashboard on the web and accessing a report, it was always possible to use a keystroke to return to the dashboard. However, I haven't been able to do this in the…
-
WEEKNUMBER and WEEKDAY
I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date/time of a request. The sheet looks at the date stamp on the request then references another sheet (using WEEKNUMBER and WEEKDAY) to see who's "on duty" at that time. That contact's name is pulled into an "Assigned"…
-
Need Formula help!
I need a formula that will do the following: When the Date in WKU column has past place the latest NewPromiseDate from the AllPromiseDates column in the cell.
-
Capture Date and Time when column is changed
Hello everyone! I want to know if there is anyway to capture the date and time using if function, when a column value is changed to "Approved" Let's say I have two columns as follows: Status Time Approved if ( [Status]@row = "Approved", Today() AND Time(), 0) is it possible to achieve this in smartsheet? Thanks !!
-
Adding Multiple Criteria + Does Not Include
Hello, Smartsheet community! I am stumped on a function. I have attached a photo of a dummy sheet with the same functionality I am trying to achieve. Using the example, how would I set up a formula which adds together the lunch selections of turkey, ham, and roast beef if they DID NOT choose soda as their drink? Lunch…
-
How to get JOIN working when referencing another sheet?
I'm using the JOIN formula, if I put the formula on the same sheet as my column references, it works just fine, however when I move this to a separate sheet and update the column references to the other sheet I get the error #UNPARSEABLE. I haven't removed any of the formula delimiters only which sheet I'm referencing. Any…
-
Copying Column Into Blank Sheet
I'm looking for a way to copy a single column into a blank sheet. When I started the project, I assumed cell link would be perfect, but that doesn't work with the destination sheet being blank. The project I'm working on uses a form that's filled out 24 hours a day. The information from the source sheet is copied into the…