-
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…
-
Pull data from one sheet to another. Nothing working.
I am trying to create a column formula which automatically pulls data from a sheet called "Employee Details". I will need to do this with data from several columns but I will focus on the "Employee Name" column here. I have already created a cross sheet reference between both sheets in the Sheet Reference Manager. In both…
-
Problem retaining formulas in cells that are in a form
I have an intake log that has a form for parents of child patients to complete in order to apply for services. I have added logic that allows the user to complete the patient's address. Then, I ask the question of "Is your address the same as the patient's" (Yes/No). If yes, I want the parent's address fields to populate…