-
When a copy row automation is triggered, is there a way to only copy certain columns/cells?
When a copy row automation is triggered, is there a way to only copy certain columns/cells in that row? I saw in a post from 2020 that this was not possible yet. Is this possible now in 2023?
-
Formula changes without showing in Activity Log?
I have this formula: =IF(ISBLANK(Location@row), "", INDEX({Location_code_helper Range 1}, MATCH(Location@row, {Location_code_helper Range 2}, 0)) + "-" + RIGHT(Year@row, 2) + "-" + COUNTIFS(Location$1:Location@row, Location@row, Year$1:Year@row, Year@row)) It basically creates a custom identifier that uses the year and a…
-
Transfer ownership of Smartsheet items
We created a workspace and made our client (from different organization) the owner, but there are still several sheets, reports and dashboards that are under our ownership. We are not a licensed user anymore. Is there any way for us to transfer ownership of all items to our client (without having to do it one by one for…
-
Transfer ownership of Smartsheet items
We created a workspace and made our client (from a different organization) the owner, but there are still several sheets, reports and dashboards that are under our ownership. We are not a licensed user anymore. Is there any way for us to transfer ownership of all items to our client without having to do it one by one for…
-
DocuSign Integration: Logging in with alternative account
We're starting to use the DocuSign integrations since we've already been using it, and like the automation offered through Smartsheet. When I set up the DocuSign and created the two mappings we have for this project, I logged into my user account with DocuSign. However, I now realize that the envelopes are sending as…
-
How do I score out a survey and have it populate in another column?
Hi everyone , I am attempting to create a scoring system for a survey based on this type of scoring below. These are the survey questions and it already built in a sheet. Thanks in advance for the support.
-
Creating price tickets
Would be grateful for any guidance please. I'm looking for a way of producing sheets of price labels including a barcode that would be generated from a smartsheet. I can get all the relevant data into one smartsheet however I have been struggling to come up with a way of creating a PDF that would contain the price label…
-
extract part of a cell's text
Hello, New smartsheet user here. I have cells that contain dimensions of objects. A cylinder, for example, looks like this: Ø120*12. I need a way to extract just the text to the right of the *, in this case 12, to another cell. Another example: Ø18*1000 would return 1000. How do you do this? Thanks!
-
Formulas with multiple inputs in smartsheets. Help needed!!
This has been a challenge for me to figure out using the smartsheet platform. I am developing what is essentially a big calculator. The formula that I am trying to implement is: [($26,000 * DTH) + (Risk R * Repair Cost) + (Risk A * repair cost)] * frequency). In this database, each row represents an additional input. The…
-
Sum of column values that come from function formula
I have created a formulation of a drop down with prices associated with each selection that population on a different column: =IF([Repairs Needed]@row = "Tuck Point", "125", IF([Repairs Needed]@row = "Tuck Point Panel", "450", IF([Repairs Needed]@row = "Tuck Point Column", "150", IF([Repairs Needed]@row = "Tuck Point Major…