-
Formula to automatically check a box when a certain cell is populated
I am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled, OR when a certain cell has information in it due to the update request being filled, I would like a certain box to be…
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
-
Project Plan with several Tasks in one Line
Hallo! Currently, we have an Excel sheet, which I would like to transfer in Smartsheet. However I cannot find a way to do so, so hopefully someone can help me. As seen in the picture, every row is an own project and every column (except the first with the name of the project) is a certain day, like a Gantt. So on every…
-
automatically export and then delete rows
We use SmartSheets to collect a large amount of data using a form. We reach the Smartsheet size limits almost weekly. Currently we log in each week, export the data to excel, and then delete rows based on a date criterion. I have looked at Zapier. It looks like I can have it email me the data in excel but the free version…
-
Reaching for Specific Information Return
I am trying to use a set of sheets for material tracking from various suppliers without actually having to have my employees use several sheets to do it. I am wondering if there is a way/formula to look through a specific column for a supplier name, and in whichever row it finds said supplier it then outputs that entire…
-
Preserving drop down list on import
Is it possible to preserve the dropdown choices when importing an excel document?
-
PDF Exports
Hi Everyone, Is there a way to export a row to PDF but select the columns that you want to include? At present, I'm printing the row and saving to PDF; however, I can only select to either include or not include comments and hidden columns. Clicking File and export to PDF does not give me the option to select columns and…
-
SUM of consecutive cells until blank cell is reached in the column
Hi, i am trying to SUM any given number of consecutive cells in column A and need it to stop once a black cell is reached. For instance The SUM will be column A, row 2 to 6 (7 is blank) and I am wanting the SUM to display in column B row 1. This will repeat throughout the sheet, but the SUM result will always be column B…
-
Cross Sheet Reference Unparseable
I am trying to use a COUNTIF statement to reference another sheet and count the number of "V" s so I can create a metrics sheet for my DashBoard Creation. I have attached a snip of it below but all i get is #UNPARSEABLE when i try it. I must be missing something, but I am unsure as to what. Received the #INCORRECT ARGUMENT…
-
Auto-hiding rows
Not sure if this is possible, but I would a row to become hidden based upon the status of a drop down. If cell is blank, nothing needs to happen. If cell is "delete" or "archive", I would like the row to become hidden. Any help would be awesome.
