-
Conditional formatting - specific for me?
As a new user, I need to get one thing clear: Is conditional formatting just seen by my user or is it seen by all users that has the sheet shared to them?
-
"Move to Another Sheet" Changed?
Has the "move to another sheet" functionality changed? In the past, it has always copied the rows to the chosen sheet and deleted them from the source sheet. I have tried it three times this morning and managed to copy them three times to the designated sheet and they still remain in the source sheet. And yes, I am sure I…
-
Parent Task Bar not updating based on conditional formating
I have a conditional format set to turn the task name bold/black and the task bar black if a checkbox is selected. The task bar does not turn black on Parent rows if the checkbox is selected. The task bar will turn black if the checkbox is selected for Children rows. Can this be fixed?
-
Keep indent on the reports (and on sights)
Hi there, I'm struggling to keep indents to materialize parents/child rows in reports. Below is the formatting in the sheet with the indent to materialize relationship parent/CHilf Is there any way to achieve that so I can keep the visibility on the parent/children in the Gantt displayed in my sights ?
-
Percent Complete - by date
Apologies if this is a repeat question, or not one of my brighter moments, but I'm looking for a way to display incremental milestone/project progress - at a glance - and by comparison to other points in time. Everything I've found shows progress as of today (where we are now) but I want to be able to see where we were…
-
Report Builder Not Picking Up All 'Modified By'
Help please!! I have built a report to pull out all data that has changed between a date parameter using the 'modified by' criteria. Prior to my making some changes today, the report was picking up all the individuals that had modified the sheet, however since the changes it is only picking up myself. I am guessing that as…
-
Prevent that modified date is set when value formula has been changed
Hi smartsheet, this would be very helpful: Make formulas configurable, if modified date is set, when resulting value is changed, or not. Background (as an example): We use a date formula called "relevance" with the result "today" for specific combinations of start dates, end dates and status. This "relevance date" is…
-
SUMIFS (Current Month Sales)
The conditions below formulates when the "Sold Date" & "Result" = (100%) in the current month/year (January 2017) When Febuary rolls over the row that calulates ("Current Month Sales") will zero out. I need a formula that captures all the sales for each month (January, Febuary, March....etc). Thinking a formula that…
-
Webforms | Survey - Customizing Column Headers or Question Content
I currently use an external tool to conduct 200-300 surveys and collect data on project performance for my org annually. Data is exported from the tool and compiled in excel. I want to transition to SmartSheet to alleviate the manual survey creation and lift and shift of data. Problem: Each survey is customized listing a…
-
IF Statement to populate cell based on Check Box & Text in same row cells
Hello Smartsheet Community Members! Is it possible to write an IF statement to populate text from one cell in the row into another cell in the row ONLY IF a particular box is check in the same row? To put this into context, I would like to display key text onto a project Sight on a regular basis without the PM having to…
