-
Formula Help Countifs Percentages
I need a formula to calculate sets of specific Date columns, and tally those date columns into a % of that set? For e.g. I have 2 groups. Each group has specific columns that make up the set for each group. There is a unique separate column that will tally the IMP Dates entered (specific to the Group). I need a formula inβ¦
-
COUNTIFS - blank search input in 1 of 2 criteria
=IFERROR(COUNTIFS({2025 Tracker v2 | Brand}, "Apple", {2025 Tracker v2 | Status}, [Primary Column]@row, {2025 PMO Tracker v2 | Year}, $[Primary Column]$1), "") Year is 2025 and @primary row is blank, however it still returns 280 items when there are no blanks items to count in Status.
-
Tracing Predecessors of Late Tasks
I am trying to create a formula to be able to show what predecessor task in the process is holding up later successors. The plan is used for onboarding physicians in a health system, so multiple areas with overlapping tasks [HR, the hiring department, the team that assigns clinic space, etc.]. The simple version of thisβ¦
-
Issue with MAX COLLECT. I am trying to collect the "most recent" date of each unique item.
I am struggling to understand where I am going wrong. The most recent entry is 01/20/25, but smartsheet keeps pulling it as 01/21/25, when there is no 1/21/25 data entry for this unique item. =MAX(COLLECT([Created Date_ED]:[Created Date_ED], [Phone Item #]:[Phone Item #], [Phone Item #]@row)) When I try to use a helperβ¦
-
Saving a template set with a workflow to destination sheet dynamically
Hi, I have a created a folder with sheets, reports and dashboards. within this folder, there is a 'destination sheet' to which a workflow on another sheet should copy rows over once 'X' criteria is met. From this 'destination sheet' I have reports running for my dashboard. My question is, if I was to resave this wholeβ¦
-
Adding Attachments to a specific row via Email
I am wondering if there is a way to send an email that would be connected to a specific sheet and a specific row for file attachments. I know other PM systems will allow you to send an email to a specific project and task that will add the attachments to that specific project or task. Is this possible? If so, how does oneβ¦
-
How to add only the $ Symbol without the currency in the PDF document?
Hi all, How can I make sure I can show the $ symbol in the PDF file without the currency? My columns shows the value without the currency: But once the PDF is generated it comes with the NZcurrency, which is what I do not want. Thanks in advance.
-
How to populate duplicate numbers into sheet?
Hello, I have one main sheet that tracks all incoming DRR #'s and every row has a couple of names in it. I want to build another sheet that tracks names based on the DRR # but want it to populate in different rows, like below. So two people are on 0001 while in the main sheet that would only be one row
-
Please help correct my formula - copy/paste results in carriage return and quotes around text
Here is my formula: =[Client Name (Avi)]@row + "-" + LEFT([Request Category]@row, 1) + "-" + MID(Created@row, 7, 2) + "-" + [Request ID]@row + "- " + JOIN([Services Requested - Utility]@row + [Services Requested - Waste]@row + JOIN(" -P")) When I copy/paste the cell (or export to Excel), the text looks like this (two rows,β¦
-
Vlook up from Mutiple Sheets
Hi All, I need to do a vlook up against a unique code, from a production plan - dates, QTYs etc. However, I have a live 1. Sheet Plan and I have a 2. Sheet archieved plan. I need to do a vlook up from the 2 sheets into a 3 sheet. Please if someone can help with the formula. Formula below works fine for one sheet.β¦