-
[FORMS] URL Query string not working
Any idea what could cause it not to work? When I add the query ?Property=ABC it just refreshes with only the URL. It is just working on this one form but not on the others. What do I need to check? I've already read the documentation. Re creating another form on this sheet does not help. Here is the link, but please DO NOT…
-
If/Then Statement with Symbols
I'm having hard time to get this formula to work: =IF(Amount@row < 0, "Red", IF(Amount@row > 0, "Green")) See attached Error. I want to show a red dot when the amount is negative and a green dot when an amount is positive. Thanks, Amy
-
Need Help with my Nested IF statement formula
I have spent at least 2 hours reading multiple Q & A's in this Community as well as watched multiple videos to no avail! I give up and need help! I have a column of Service Years (Y1, Y2, Y3) and want to add statement in adjacent column dependent on the Service Year. Y1 should be "2023-24" / Y2 should be "2022-23" and Y3…
-
Weeknumber
I am trying to pull data for a certain weeknumber. I dont want to use today or today-1 because I want this data to be tracked throughout the quarter? Here is what I have currently trying to find the data for Weeknumber 13. =COUNTIF({PBR_DateOnly}, AND((IFERROR(WEEKNUMBER(@cell), 0) = WEEKNUMBER(13), IFERROR(YEAR(@cell), 0)…
-
Need to Sum Countif of an entire column when the Smartsheet columns change
We had a procedure that worked well summing an entire column using sum countifs. But we noticed when a new column is added to the referenced sheet it causes the function to break. What other function will work in the same way but also not cause it to break like the current function does when a new column is added.…
-
Formula error when filtering an unchecked flag column & filled cell (in column)
Hi, I've been trying to complete a formula that counts the number of unchecked flags when a cell states approved. Here is my current formula that responds with UNPARS =COUNTIF([Pause New Grp Reg Reminder]:[Pause New Grp Reg Reminder], OR(1, 0), AND([Facilitator Status - Certificate Completed]@row:[Facilitator Status -…
-
Ranges
Hi, I am using "Ranges" when I use vlookup etc, but I don't know how to completely delete a Range (or multiple Ranges) Does anyone know how to delete all "old" ranges from within smartsheet memory? I think I need to free-up some resources, I keep getting the error message; "You can only reference 25000 cells" "Please…
-
Formula Help!! Trying to pull text from a non-lank cell into helper column
Hey Smartsheets community! I am struggling on what I thought was an easy formula but I am completely stumped. Essentially I am trying to write a formula in the 'Current Statement' column that would look at the 5 statement columns to the right and pull in the comment from the most far right column with text In the example…
-
Countdown for days until due but stop counting after due date has passed
Hiya, I am trying to write a formula that will count the number of days until a task is due but will not start showing negative numbers once the due date has gone by. I came up with =NETWORKDAY([Today's Date]@row, [Date Next Check/Validation Due]@row) But couldn't figure out how to make it be blank once the Date Next…
-
Can I display all the values from a column on one sheet to another?
Hello Smartsheets, I'm attempting to have a sheet which can display the values of a particular column on "sheet A" to a column on "sheet b." Sheet A's column has repeat information (job names) that associate with different items. So the job name on Sheet A shows up multiple times with different items in different rows. I…
