Formula to copy value only

ergibson

I'm trying to pull a date from a cell that uses a "minimum" formula to express the earliest date from three cells containing dates. The cell with the "minimum" formula provides me with "date physically received." I now need to count how many days have passed since "date physically received."

Is it possible to use a formula to transfer the value of the cell with the minimum formula to a new cell in the same sheet? Is there something like a "paste values only" formula?

Here's the "minimum" formula I'm currently using:

=MIN([3Date - In Warehouse]@row, [5Date - Holding in Quarantine]@row, [6Date - Quarantine In Progress]@row, [7Date - Review and Inspection]@row)

TIA!

Zachary Hall

@ergibson

If all you need is the number of days that have passed since the MIN() date you should be able to use:

• =TODAY()-MIN([3Date - In Warehouse]@row, [5Date - Holding in Quarantine]@row, [6Date - Quarantine In Progress]@row, [7Date - Review and Inspection]@row)

jmyzk_cloudsmart_jp

Hi @ergibson

Can't you just compare it with the TODAY?😀

=TODAY() - [date physically received]@row

https://app.smartsheet.com/b/publish?EQBCT=aa70dd4703bd4c3089989fb9131cf731

Zachary Hall

@ergibson

If all you need is the number of days that have passed since the MIN() date you should be able to use:

• =TODAY()-MIN([3Date - In Warehouse]@row, [5Date - Holding in Quarantine]@row, [6Date - Quarantine In Progress]@row, [7Date - Review and Inspection]@row)

jmyzk_cloudsmart_jp

Hi @ergibson

Can't you just compare it with the TODAY?😀

=TODAY() - [date physically received]@row

https://app.smartsheet.com/b/publish?EQBCT=aa70dd4703bd4c3089989fb9131cf731

ergibson

Thanks @Zachary Hall, Thanks @jmyzk_cloudsmart_jp! That solved the problem. I guess I was overthinking it! Your help much appreciated!