-
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…
-
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…
-
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…
-
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?
-
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!
-
Removing Zero Values From Chart
I am trying to create a stacked column chart to show how many Statuses are being used per section (Section for Chart) in a project plan. However, I do not want any zero values to show. I have attempted to create a report for this chart, but I cannot get the chart to look the way that I want. What I want (minus the zero…