-
FY Q1-Q2-Q3-Q4
Hello there, looking for some feedback. I currently have this formula to identify FYQ. My FY goes from October-Sept. =IF(ISDATE([Referral Date]@row ) = false, "", IF(AND(YEAR([Referral Date]@row ) >= 2024, YEAR([Referral Date]@row ) <= 2025), IF(OR(MONTH([Referral Date]@row ) = 11, MONTH([Referral Date]@row ) = 12,…
-
Referencing another sheet to have automated assigning of files
I have attempted, several times, to follow the exact formula provided on AI so that I can assign new rows to random users. The AI formula showed: =IFERROR(INDEX({Team Sheet Names}, MATCH(MOD([Row ID]@row , MAX({Team Sheet Order})) + 1, {Team Sheet Order}, 0))) Following the directions and making the sheet reference, I…
-
How do I check an entire column for a particular value and only display the lowest example of it?
The question title is kind of confusing, so here's what I'm looking to find out. I'm making a Project Plan sheet, and want to have a place that updates the estimated completion date based on how the project has progressed thus far. There are more columns in my sheet, but my question is only related to the ones in the…
-
Modified Date in Formulas
I am trying to use the auto-populated system column "Modified" in formulas. Specifically, I am trying to create a "Modified Helper" column that takes the "Modified" column date alongside the time, checks if it is after midnight, checks which shift it was logged under, and log the auto-populated "Modified" date to reflect…
-
HAS function help
This discussion was created from comments split from: Ready Status Solved - I hope this helps everyone.
-
Can you copy / export workflows, conditional formatting and saved filters to other worksheet
We stated using Smartsheet back in November and I have a few active Smartsheet for projects and more we use it the more I find things I want to do across all sheets. If I add a workflow, conditional formation or saved filters to a sheet is there a way to export them and import them into another sheet? I know I can use a…
-
Index and Match Formula with IF statements
I think I need an Index and Match formula, but cannot seem to find the correct syntax. Sheet 1: Intake Sheet I have an intake sheet that tracks an Intern's "program" and the semester it was completed. It is intended to track the intern's complete record. The sheet tracks this information over a potential three (3)…
-
Un Join numbers in a cell
Is there a formula to un Join numbers in a cell. have a cell that contains this I want to pull each of those numbers out into its own column/cell Is this possible?
-
Lookup Formula Not working
I am attempting to do a lookup of a a Date (on the Deliverable Tracker, shown in screenshot #1). The lookup will use the Effective Start and End dates to find the appropriate range, then the end result will be the text value column at the far right. My formula shows a blank result, here is the formula:…
-
Formula Help
I'm looking for a formula in column D belw that does the following: Subracts column A from column B, unless column C has an amount. If it does, then I need column A subracted by column C. Row 1 should be -2 Row 3 should be -5 Is this possible?