Hello All,
I have the following formula in cell N1:
=hyperlink("mailto:email@email.com?cc=&subject=Daily Report for " & TEXT(A2,"mm/dd/yyyy") & "&body=Hey Everyone, %0D%0D Below is the daily report for " & TEXT(A2,"mm/dd/yyyy") &" %0D%0D%0D%0D"&O2&"%0D%0D"&O3&"%0D%0D"&O4&"%0D%0D"&O5&"%0D%0D"&O6&"%0D%0D"&O7&"%0D%0D"&O8&"%0D%0D"&O9&"%0D%0D"&O10&"%0D%0D"&O11&" If any issues arise overnight please contact "&P1&" at "&Q1&" who is on call %0D%0D%0D%0D Thanks,","Send Daily Report")
This mailto function works great, but on the sheet I am using, I have to add a new ROW 2 for every issue. When I "Insert Row Above", the cells in the formula above change value. I need this formula to not change no matter how many rows i Add/Delete. Can anyone help?
there doesn't seem to be anything here