-
SUMIF Formula for Multiple Criteria from Multiple Sheets
I want a tally of the results in {Master-# of Assets} and {VisionHub- # of Assets} from two different sheets (that are almost identical in columns) I want a formula that will give me this tally across both sheets with the condition that the Team Managing is in the Primary Column and the FY is in the [Primary Column]$2…
-
Total of Certain Value Across Multiple Sheets
Hello! Hoping someone here can help. I have 6 sheets that are identical in setup and parent rows (inventory for each vendor - Child rows are only varience being actual inventory). I'm needing a summary sheet that totals the quantity across each of the 6 vendor sheets. I've tried a variety of…
-
Need formula to check a box if another column is under < $1,000 remaining.
Greetings- I need a formula to select the Alert checkbox if the Remaining $ is under $1,000 left. One time Id also be curious if possible to do this based on a percentage left of the original PO Amount. ex If I have 10% of the original starting PO amount left. Thanks for any info! MD
-
How to ignore blank cells in health formula
I have a working formula for task health based on % Complete and Target Completion Date (see below). I'd like this formula to ignore any rows with blank Target Completion Date and display nothing in the Health column if there is no Target Completion Date. Right now it's defaulting to Red. I know I should add ISBLANK, but I…
-
Pre-Filled Form URLs
Hi SS Community, I created a formula that builds the URL below to pre-fill fields on a form using values from a table. The resulting string works when I copy & paste it into a browser window, but not when I click on the link in the Smartsheet table, the last field (Personal Email) is blank. Does this mean that there is an…
-
Calculate start date based off of end date
Hi All, Can someone help me with a formula? I've searched the community and haven't been able to find an answer. I already have a formula in place to calculate the end date based off of the start date and duration of project. However, if I have an already defined end date I'd like to calculate the start date based off of…
-
Checkbox with IF AND formula- satisfy two criteria simultaneously
Hi, I want to add a formula to a checkbox column, the purpose is to automatically check the box once the cell satisfies two criteria simultaneously. Criteria 1: Phase column=Milestone Criteria 2: Finish Date column<= 03/11/2024 I have tried a few IF AND formulas but still can't get the result desired, loosing temper now :(…
-
Could someone help me with this sheet summary formula?
I'm trying to create a formula that adds the amount in the "Amount" column only if the "Revenue Period" column contains "2024". When using this formula I get "0".. =SUMIFS("Amount", "Revenue Period", "*2024*")
-
RANKEQ with a date criteria
Hi there, I am trying to pull the most recent fee payment value from each regional group. I want this to pull through to a report so that I can see that most recent payment value In a report where all the regions appear once. I have the region column (called DNO) the fee payment column (called A&D fees) and the date column…
-
Counting Dates within a specific month
I am trying to count the number of entries per month. My formula for January specifically is below. Can anyone fix this? =COUNTIF({Sourced Date}, MONTH(1))
