-
Formula To Return Value based on Month
Hello, I am attempting to recreate a formula I have in Google Sheets to return a quarter number based on the Month. Ex: If a cell has "March", it would be Quarter 1. The original formula involved =IF(OR(ISNUMBER(SEARCH("December", F3)), in Google Sheets and I was able to have it work, albeit with several lines of text…
-
How do I collect the most recent row data under a parent?
I have a sheet that I collect our vehicle information on each month. I manually move new rows to under the correct parent row. The issue I'm having is I can't find a formula to collect the most recent data from the children rows. I want the parent row in each circled column to behave the same way latest comment does and…
-
count if / v lookup formula
I'm trying to count the number of times the issue "- Originating Agency should be the origin of funds for University pass through funds" appears on a scrub report. I was using a simple count if statement at first but ran into an issue when two issues were reported for one proposal in a cell. I thought a work around would…
-
Need help with multiple If formula
Hello - I am having trouble converting an excel Ifs formula into smartsheet. I am able to get a single If formula to work, but cannot link them to each other - or even know if it is possible. Full disclosure, I am not very familiar with more advanced formulas. I have a column that has multiple entries. I created another…
-
Calculate Start Date using a formula
I want to calculate the Start Date of a task using a simple formula. This is the Start Date column that interfaces to Resource Management, so that task and calculated Start date will be populated on the Assign To person's outlook calendar. Everything works EXCEPT the Start Date field does not seem to allow entering a…
-
Reminder Automation based on the Forgetting Curve
I am currently working on a project where I would like to set up automated reminders based on the Ebbinghaus Forgetting Curve to maximize information retention for my team members. I plan to use the following reminder intervals: 1 day, 1 week, and 3 weeks after the initial learning event. I aim to create a system within…
-
Invalid Operation for simple formula
I have this formula that is returning INVALID OPERATION =IF({AMR Location} = "Baltimore Mfg", AVG({AMR Level}), "") The Location column is just text. The AMR Level is a number that is calculated from a pick list column. =IF([Level of Professionalism]@row = "1", 1, IF([Level of Professionalism]@row = "2", 2, IF([Level of…
-
Help With Remaining Work Days Formula
All, I'm in need of a formula that calculates remaining work days within a "start date" and an "end date". I came up with this: =IF(ISERROR(NETWORKDAYS(TODAY(), [Start Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row)) - which works fine as long as "today" currently falls within the "start date" and "end date". But, I…
-
Data Mesh: Source vs Target sheets
Hi all, I'm creating a work flow to integrate a number of services that my team offers. There is a work sheet that captures all projects sent our way and assigns them to 1 to 3 services - and those projects show up on their respective work sheets via Data Shuttle. Currently - I have cross sheet formulas set up such that…
-
Formula to Collate Entries based on Criteria
Hi I'm looking for a concatenate type formula that will collate a number of line item updates based on their project ID. I have a sheet that contains multiple tasks for a project, each having an update. I want to collate all the task updates, based on Project ID, into a rolled up view to give one overall update of the…
