-
Formula help
Hello, I have been trying to work this one out. Attached is a picture of the column that i wish to tally. This column is a checkbox column and there are multiple parent lines (these are the colours lines) The top line is the grandparent line the white rows are the children. So what you see is each children row has some…
-
Functions for predecessors
Are there Smartsheet functions for enumerating the predecessors of a row? I've been prototyping SmartSheets for managing a pretty sizeable research project (multiple FTEs over several years), potentially replacing Asana for group project management. The reporting is nice, as is the combination of spreadsheet, gantt, card,…
-
Conditional Formatting Cell Level
Hi, I need help or guidance in Conditional Formatting at CELL Level not all rows or all columns. For example: if the % is Below 30 its RED, 30 - 80 its Yellow and 80 + is Green. Please see attached the photo for more clarification. Thanks and please help.
-
Sum Children If other cells are Checked
Hello Community, I'm trying to get a sum of children cells if a checkbox in another column is checked. For instance, if Column A has row 1 checked, I want the Column 10 row 1 counted as part of the sum.
-
Meeting agendas for Local government
Hello, I am wondering if anyone has used the Meeting Management template to create a Council meeting agenda? If so would you mind sharing how that works for you. Thanks, Jaquisha
-
Cloning a column within a sheet
Has the cloning of a column within the same sheet feature been developed? I saw the discussion back in 2016. Thanks Christi
-
unable to attach Onedrive files
When attempting to attach a Onedrive file in our smart sheet by clicking on the paper clip it comes up asking us to pick an account as attached. But after that it just sits with a wheel going around indefinitely. Has anyone else encountered this issue? Regards, Ashley
-
#Unparseable error
Hi I am new to Smartsheet, I am trying to calculate a row call Total Billable for each month of for our total amount of jobs completed. The format I'M using is as follows: - =SUM(Total Billable820:Total Billable828) it comes up with the error #Unparseable Can someone please advise me what I am doing wrong?
-
Counting party size from Symbols
I would like to use the party size symbol in a form for registration, but am not seeing a formula that would count the responses?
-
Report view without access to underlying sheet
We are attempting to create a report view that is a subset of rows driven by a column flag. We have found that the report viewer will also have access to the underlying sheet with all of the details. Our goal it to provide a highlevel summary via the report and restrict access to the subtask details.