-
# 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)))…
-
Total Sum not calculating in Smartsheet correctly
Hello SmartSheet Community. I have created a report with various categories and totals. I wanted to capture certain categories and their totals however the totals are not calculating correctly. I would have to copy the totals, paste them to an excel blank sheet and AutoSum there. Can someone see what I am doing wrong?…
-
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,…
-
🇦🇹 Smartsheet User aus Österreich hier?
Servus zusammen 👋 Gibt es hier auch Smartsheet‑User aus Österreich? Es wäre cool zu erfahren, wer in der Nähe ebenfalls mit Smartsheet arbeitet – zum Austausch von Erfahrungen, Best Practices oder einfach zum Vernetzen 😊
-
Next Outreach Due Formula Help
Hello, I’m looking for assistance with a Smartsheet formula I’m working on and could use a second set of eyes. What I’m trying to achieve: I’m currently working on an outreach program that needs to calculate the Next Outreach Date based on outreach activity. Our team makes up to three outreach attempts, and we also have an…