Formula to copy value only

Options

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!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!