-
Formula for Imported Data
All, Im importing data into smartsheet from excel and there is a lot of extra information in the file. How do i copy select columns over into another sheet? I will be doing this on a weekly bases can i create a "raw import sheet" that will automatically copy the information over to my preferred sheet? I will be deleting…
-
# of occurrences formula
I want to show how many times in the past six months that a supplier has had a complaint issued against them. This is the formula I am using but it returns all zero's. =IF(Supplier@row = "", "", COUNTIFS(Supplier:Supplier, Supplier@row, [Date Submitted (Created Date)]:[Date Submitted (Created Date)], ">=" + TODAY(-180)))…
-
Reporting by month
Hello! I'm creating a reporting dashboard from a Smartsheet that tracks all incoming project types and I'm hoping to report a breakdown of the number of projects that are due each month. Is this possible with a particular formula? I'm coming up with a lot of errors. Thank you!
-
Index, Match formula returning some, not all values
Formula was flowing correctly, but some change seems to have partially broken the pull but I can't figure out what/how. "Project" column dropdown is linked to a Master sheet. Budget Owner column contains the below formula which should look for the cell value in the Project/Cost Center/IO column within the P+CC+IO column of…
-
Match / Sumifs formula
Hello! I am looking for a formula to match the entry in sheet 1 to the entry in a sheet 2, then sum a column in another sheet 2. Would a match or vlookup formula work best? 1 - Match Primary, Tower and Blade columns in sheet 1 to Site Name, Turbine Number and Blade Number Sheet 2 2) Return sum in Travel Hours column from…
-
Extracting Multiple Data from one cell into multiple cells - same row
I have a smartsheet where I'd like to extract data from the LIST ALL occupants column and place them into Occupant 1, Occupant 2, etc. out to 13. I have this working for columns 1 and 2, but then it repeats, even though I change the +# in increments of 1… and if there are no additional names, I'd like it to be blank.…
-
Enable attachments in automations when using 'message only' option
We receive data from externals which we then need to verify. Once it's verified we then email them back a PDF (that's been generated using 'generate document' feature) as it contains the crucial information that's been verified, and they can keep as a confirmation. Currently, I use the message only format in an alert…
-
Structure for a worksheet with many columns
Hello, I am fairly new to Smartsheet. I am trying to create a worksheet for projects (1 row per project). My pain point is that I have too many columns for each project (info, timelines, vendors, contacts). My initial thought is to create separate sheets for each of the categories (master list, info, milestones, vendors,…
-
[Critical Error] Owner of the sheet can't edit despite having a Business Plan Member seat
Hi, I’m the Owner of several sheets, but I’m currently being treated as a "Viewer" and cannot edit anything. The Issue: Even though my Seat type is correctly set to "Member (Paid)" (as shown in the attached screenshot), I have no editing rights. System Error: On the User Management page, multiple error messages saying "We…
-
Reactivating Business Plan: Will my existing sheets and permissions be fully restored?
Hi, I have a question regarding reactivating my Smartsheet subscription. Previously, our team used a Business Plan with one Admin (Owner) account and two additional licensed users. We canceled the annual subscription some time ago, so our account is currently inactive (or in read-only mode). If I log in as the original…