-
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
-
Count Children Specific Year
Hi! I keep receiving the "unparsable" error when trying to Count from Children (sub rows) for a specific year. Current formula entering is =COUNT(CHILDREN([Alliance Partner(s)]@row), ([AM/PM Years Active]@row, = 2024)) Note: AM/PM Years Active column is a multi-select for the years active for those rows/subrows. Any advice…
-
Using SUMIFS formula with CONTAINS or HAS as Criterea
I'm trying to only add up budget line items from specific months and that do not contain the value "Total" in their account code. Here's the formula I have and just can't get right. After breaking it apart, I'm finding the CONTAINS part of the formula is what's incorrect. =SUMIFS({Budget Detail $}, {Budget Detail Acct…
-
INDEX COLLECT formula when the Criterion contains more text than Criterion Range
Hello, I have a formula that works correctly to index "Obser 1" text when there is only one "Vendor #" in the Criterion cell and there is an exact match to the "Vendor Number" in the Criterion Range column. =IFERROR(INDEX(COLLECT({Obser 1}, {Vendor Number}, $[Vendor #]$1, {Vendor Location}, $Location$1), 1), "") I need…
