-
What happens to my automation if I run out of rows?
Hey there! I am working with a large archival destination sheet: We haven't hit 20k rows YET, but it'll probably be coming this year. The automation moves Completed rows from an active tracking sheet to the archive sheet- we keep that for a full accounting of these completed processes. But.... what happens when…
-
Get Average of "checkboxes checked" for an entire column reference from another sheet
Hi Everyone - I'm trying to get an average of "checkboxes checked" for an entire column range. I came up below but it's not working. =COUNTIF({1 Main Speaker System Range 2}, 1 / COUNT({1 Main Speaker System Range 2})) I was successful to get an average of a row range because I divided by a fixed number. Here is the…
-
Max out Cross sheet reference ?
I have an error message "unable to create cross sheet reference because this sheet already contains the maximum number of different cross sheet references." How to resolve this issue? I already deleted many rows to reduce the cross reference but didn't work.
-
Vlookup a cell with a formula
Hello everyone, I am trying to use a normal Vlookup function in smartsheet. The search_value (number) and also the value that is supposed to be looked up in the look_up table (same number) are also pulled with other formulas. If I hardcode the numbers instead of suing a formula, then the Vlookup works. Does this mean that…
-
TotalFloat inconsistency between parent and child tasks
I am looking to utilize TotalFloat in a project plan and am finding inconsistent results with parent and children tasks. The sheet is set to Mon-Fri working days with no holidays set. The formula in use is =TOTALFLOAT([Task Name]@row) + " days" From what I am seeing: -The manually calculated delta between Line 14 and Line…
-
Reset a Row
Hello, I am looking for a way to have certain cells in a row "reset" once a checkbox (in that same row) is checked. When I say "reset", I want two cells to go back to being empty and another cell to have an updated quantity. Is there a way to do this? Maybe multiple automations? Appreciate any help or ideas!
-
Count and Concatenate Text
Count the total number of checked boxes in the children rows of [Completed] and compare that number with the total number of checkboxes using concatenated text. Your answer should look like this: "Total Completed: _ of _"
-
Links connecting one sheet to another are not working - how can I resolve this?
Links between sheets are not working. I've seen status updates on this from people in the past, but am not sure if this is an ongoing issue or if it has been resolved. If I need to submit a ticket to SmartSheet, please advise or advise how I might be able to fix this myself. Thanks!
-
Changing the default Timeline Display for Gantt Charts?
Hi there, Is it possible to change the default Timeline Display options for Gantt Charts (whether in Sheets or Reports, or ideally differently for each) such that when a new user views them for the first time they see the settings that the author intended? Right now, if I set these options for my own view of Gantt Charts…
-
COUNTIFS+CONTAINS
I get the message UNPARASABLE, what am I doing wrong? I want to count the non blank fields in rage 1, when in range 4 I have a certain value AND is the range 7 = OPEN value. =COUNTIFS({Final RISK/ NON CONFORMITIES GROEP AERTSSE Range 1};<>"";[{Final RISK/ NON CONFORMITIES GROEP AERTSSE Range 4};…
