-
Auto Numbering based on Impact and Date
This is a follow up to my previously posted question. https://community.smartsheet.com/discussion/137520/auto-numbering-question I am trying to number just the gap items, but all the high impact should come first in date order, and then medium impact in date order continuing. I was able to get it to start over the count…
-
Avoiding a 0 result
Hi! Context: We have tokens that are being spent at farmers markets. We call those "Incentive Redeemed." They originate from two different programs, funded by two different grants, and because they are identical when they are redeemed we do not know from where they originated. We call those "SNAP Incentive Issued" and…
-
Rolling Negative Status Up Hierarchy from Children
Hello, I am working to streamline my project timelines for quicker daily tracking. I currently have a formula based on the task completion % and end date that gives a status and conditional formatting for the negative statuses: "At Risk" & "Late". It works great at the lowest level, but I am running into issues where I…
-
Help with Join+Collect Formula
I need to reference another sheet to join and collect the skills of employees. The yellow is my desired outcome, and I'm using the following formula. Formula: =JOIN(COLLECT({Detailed Resource Data Master Range Skills}, {Detailed Resource Data Master Range Emp ID}, [Employee ID@row), ",") I'm not getting any errors, the…
-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
INDEX, DISTINCT, and MATCH formulas
I am trying to put together a list of our project managers and which business units each of them are responsible for. I need it to be in a certain format because right next to each of the business units, I am going to have 3 COUNTIFS formulas to count different things based on the project manager and business unit. I…
-
Help with referencing data that is input through a form
Hi all, I'm hoping someone can help me with my specific issue that I cannot seem to resolve. In our Workspace that is set up through control centre, we have a sheet called a Checklist that is populated for each of our provisioned projects. The information in the sheet is populated via a form, as there is around 50 columns…
-
Convert a Sum into Currency format $#,##.00
I have a formula that creates a note and within that note is a sum of numbers. For example, JOIN("This is your total: $" + round(sum([Number1]@row, [Number2]@row), 2)) When I use this formula, the results look like "This is your total: $34000.00" when I need it to return "This is your total: $34,000.00". When I use…
-
Question about currency formatting
Hi, I have a helper column I am using to insert text into an email alert (the 2000 characters is not enough for my needs so I'm using several formulas to insert the data). Anyway, one of my columns is my "Header text" for the email and it includes the name of the person making the transaction, the transaction total, date…
-
SUMIF formula issues
I am trying to write my 1st SUMIF formula based on a suggestion from a colleague but not coming right :( We are setting up a budget tracking sheet for the organisation to use as many people will be adding rows to various categories I am trying to write a formula that will check the Category in the "Activity" column and…