Combination of free text and formula in one cell


Dear community,

Do you think there is a way that will allow me to enter free text in a cell which has a formula in case the formula does not return any value? Or a workaround?

I linked two sheets.

Sheet 1:

"Report No.1" - range, "Country+Disease1"(text)- match

Sheet 2:

"Report No.2" - my search value, "Country+Disease2"(text)- v lookup function column.

If the Sheet 1 has the same Report no, then Country+Disease2 is prepopulated with data from the Sheet1. But it there is no report number to match in the sheet1, I need to be able to enter a new value in Country+Disease manually. If the formula is there, I cannot.

Could you help me, please?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!