-
Adding New Rows
Hi, When adding a new row, I cant figure out the rule for indenting. Sometimes it will be correctly indented the same as the row above it. Sometimes it will add new row as a "Parent" and then automatically make everything below it the "Children" Is this caused by the way I'm inserting, or is there a default setting to make…
-
Saving Indented Row View
I love the Indent feature and especially the CHILDREN() function. Every time I save sheet or switch back from another sheet, my hidden indented rows completely expand & I have to re-click everything to find where I am. What am I missing to make sure the rows stay hidden until I need them? Thanks INB
-
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?
