-
Highlight "e" in duration column
Hi, I'm trying to highlight all tasks with an "e" in the duration column, since "e" overrides all weekends and holidays I need to be mindful as to not forget an "e" somewhere when the schedule changes. The Conditional Formatting does not work to highlight it by just saying "if duration contains 'e' then apply this…
-
Smartsheet Updates
I am curious what other users would think about this. I was working on a project recently and worked out the formulas in Excel since that is where I have more experience. Got everything worked out and it was awesome, and all the formulas worked well within Smartsheet, besides one. The one formula that did not work was an…
-
Is there a way to refer to another "row" within comments/conversations? Refer to unique rows via URL
As a Smartsheet user, I want to be able to refer to a row when typing a comment so I can better give context and easily give URL's to navigate quickly to the other row. ---------------------- Use Case: I leave a comment on Row 1. Row 1 is named "Product Plan". Within the comment on Row 1, I'd like to quickly refer to row…
-
Does anyone else have issues with Smartsheet not fitting within your screen? (Grid View)
I've always had issues (in grid view) with the current cell being able to go offscreen at the bottom, but now I'm also having issues with the current cell being able to go offscreen to the right when the workspace panel is open. The bottom one is manageable, because you can just keep arrowing down to new rows, but you…
-
Workaround to sort Report rows manually?
Anyone have a workaround solution to sort Report rows manually? For example, we need to put priority items at the top - but that priority is manually adjusted (not logical). Using a 'Priority' column to sort by doesn't work, because they want to move around and see how it's adjusted without having to save and refresh the…
-
Assigning Score to Multi-Select Dropdown Menu Options
Hi, I need assistance with assigning a score for outputs using a multi-select dropdown menu. Essentially, I want to be able to assign a numerical value when someone selects a choice from a multi-select dropdown, however, I am only able to assign a score for one answer. When multiple options are selected, the IF formula I'm…
-
Does anyone know how to use "Row Link" in reports?
I have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned & active tasks show across all project they're on. This gives an easy link to the project sheets,…
-
Contact List - Extract First / Last Name?
Is it possible to target the first or last name of a contact inside an alert email? So e.g. if I have a contact called "John Doe" in a [Contact] column, and I send an alert with Dear {{Contact}} I will get the full name. Is there a way to only get the first name?
-
Edit Start, End, or Duration from Report
I'd like to be able to edit the Start Date, End Date, or Duration of a task from my report. At present I can only edit Start and Duration from a report because End is treated like a formula. This is problematic when I need to adjust both dates because it forces me or another user to do math (accounting for non-working…
-
Reference Sheet Summary fields in formula in sheet
I need to create a formula that concatenates (JOIN or "+") several fields in my sheet summary, back into a column in my sheet. What is the syntax I need to use to be able to reference sheet summary fields? Thanks!