-
Counting Formula Help
Hi, I am looking for a formula that counts that instances that a particular department was listed. In my scenario, Person 1 & Person 2 belong to the same department. Current formula I am using is Attendances by Person 1 + Attendances by Person 2 which gives me a result of 6 however, since they are from the same department,…
-
Need Assistance in Formulae
I have 2 tables as below, I need assistance in populating column Notification Table 1 Table 2 : Ask : Based on the Title of the task, I want to pull all the users associated with it. I was able to perform for one title value with Join and Collect. I need assistance modifying the logic so that if the title contains 2…
-
Countifs with OR
I feel like I almost have it: =COUNTIFS({MMES},"0", @cell), {Disease Extent}, OR(CONTAINS("Proctitis", @cell), (CONTAINS("No disease activity", @cell) Count if the column titled MMES has "0" and the column titled Disease Extent has "Proctitis" OR has "No disease activity" HELP!
-
If cell in column contains "ASAP", change value of cell or match another cell's value
Hi Smartsheet Community! Issue we are trying to resolve: We have an intake request form that provides the client with an opportunity to request a preferred start and end date range or fill in with "ASAP". However, when the client enters in "ASAP" it causes the Requested Work Week column to have an error, which causes the…
-
AMI Estimator Formula
Hello! Has anyone set up a formula in Smartsheet to calculate the Area Media Income (AMI) Percent? I would like to enter an amount into a row and set up a formula that calculates what percentage of AMI an applicant is. I think it would be a long formula that might include all the different amounts of AMI income. Thank you…
-
I need help with a formula for Schedule Health.
Currently its working in reference to "Todays" date only. I need the formula to take in consideration the "Completed Date" and not turn "Red" or "Yellow" if the task has been completed by the "Target Date". Currently using: =IF([Target End Date]1 < TODAY(), "Red", IF([Target End Date]1 = TODAY(), "Yellow", IF([Target End…
-
Percentage Formula's
I have a beneficiary nomination form I am asking employees to complete, I am giving them the option of 4 beneficiaries, but would like to be able to tally the total percentage amounts they input per beneficiary as they complete the form to a total of 100%. So would be 4 fields/columns allowing percentage inputs, if they…
-
Edit cells with column formula
Is there a way to edit the cells where a column formula is used? I am trying to link information from 1 database to another via a INDEX MATCH formula, so we don't have to re-write info 2 times. However, the databases does not contain the same projects (we link info based on project number). See below - Project name is…
-
Merged: Bring in Multiple Contacts to a Contact List Field using Index Match Functionality
This discussion has been merged.
-
Make a link reference in a sheet to data in a report?
Hello, I want to link data from a report (a grouped sum amount) into a sheet with a reference link and/or add it to a formula. How can I pull data from reports to use in sheet formulas and/or rows/columns? Thank you, Angela
