-
I am trying us an IF statement to populate text in a cell, based off value in previous cell.
=IF(RPN@row > "400", "HIGH", IF(RPN@row < "150", "LOW", "MEDIUM")) Based off the values, the text does not always populate correctly. Example - a value of 5 will come back as "HIGH". A value of 25 shows "MEDIUM". A value of 125 shows "LOW".
-
Text to different Rows - Split by delimiter.
Hi, I have a cell@row value in the column Zone1 separated by a delimiter which needs to be split into different rows as a list of values similar to column Zone1new. Could i get help on this?
-
Looking for Smartsheet Developer for Client
Hello there! New to the community and excited to dig in! We are looking to help one of our clients hire a Smartsheet developer/builder/all around zen master for some contract work building some complex solutions for operations in underground infrastructure. Curious if anyone here is looking for some side work, and/or if…
-
Divide by Zero error when averaging 2 linked cells
I have linked 2 cells from another Smartsheet that are child tasks to my project plan. When trying to average the linked cells in the parent task, I am getting a divide by zero error. The linked cells are not showing 0 in their calculation. I'm at a loss. Can someone help me with this error or explain why this error is…
-
Set dashboard logo in blueprint automatically using value in cell linking to URL?
Our City has 40+ departments which are treated like separate companies. They each have their own logos that they like to use on their dashboards. I'd like to make it so that we can set the logo to a URL based upon their department name. That link would refer to a URL or even a file we have stored. EG. Sales would be…
-
Dynamic View: Change Source Sheet
I have a number of relatively complexly configured dynamic views (help text, display logic, etc.), and I need to preserve all of those features for each of the configurations (which I can accomplish via a save as new), but I also need change the source sheet. It would be nice to be able to change the source sheet for a…
-
Move Form to Different Folder
When creating a duplicate of a sheet/form, it would be beneficial to move it to another folder. Say you have a 2024 sheet/form and want to update it for 2025- you would duplicate the 2024 version, update it, and save it in the 2025 folder. Currently that is not an option.
-
why am I not admin on my own sheets
I am the owner but when i add the sheet to my dashboard it says I have no permissions. please help
-
Index Collect Formula (i think) question
I am trying to return a value from another sheet based on 2 pieces of criteria. I am looking to return the "Date Requested" data based on the "Operator" and "Request Type" criteria. This is the formula I am using. I am getting an INCORRECT ARGUMENT error however. Appreciate any guidance =INDEX(COLLECT({Operator},…
-
Does anyone know if it is possible to copy conditional formatting from one sheet to another?
I see some posts from a few years back. We have Bridge, would this be a solution?