laura.buchanan — Smartsheet Community

Thanks SO much!

inNeed help with IF formula using dates Comment bylaura.buchanan 03/23/23

Gentlemen, Thanks so much for the suggestions! I changed Hire Date to Column A and added a Column B so it would be easier to just copy and paste. It is fine for me to use two columns, simpler that way. Both of the suggestions work great! I am SO HAPPY! Smartsheet is SO MUCH FUN! Can one of you dissect these formulas for me…

inDisplay date from different row in same sheet Comment bylaura.buchanan 02/28/23

Thanks so much!

inIs it possible to use conditional formatting on every other row? Comment bylaura.buchanan 06/22/21

Kelly, Thanks SO much. I'm am saving your notes for the next time I have to jump through deconcatenate hoops. I actually engaged Rich Taglieri from the customer support line to help come up with a better strategy for what I was trying to accomplish and as it turns out I'm not going to have to do the deconcatinating. BUT I…

inHow to deconcatinate Comment bylaura.buchanan 01/29/21

Bassam, you're brilliant! Thanks so much!! I do need a tad more guidance. The number of letters in some of the data is different in length, so it caused things to get "off" a little. My formula worked great for New provider class on Tuesday, but when I dragged it up the entire column, Wednesday took up more letters, so the…

inHow to deconcatinate Comment bylaura.buchanan 01/24/21

Andree's work around was a great suggestion! Thanks so much. Here is what I was trying to do. I had one sheet that was a "countdown" number of days we have to accomplish an important team task. That's on one sheet. On another sheet is the list of all of the tasks and lots of information about them and lots of summary…

inreference another sheet - not from a cell, but pull from sheet summary formula Comment bylaura.buchanan 11/21/20

That worked perfectly!! Thank you! L

inCOUNTIF not blank Comment bylaura.buchanan 11/06/20

I tested it and it works!! Thank you thank you thank you!!!!

inNeed formula to pull data from Last week Sun through Sat Comment bylaura.buchanan 08/10/20

Gosh, this sure is hard....and you're doing the heavy lifting. :-) It sure seems that this last version should be correct based on the fact that you tweaked the numbers by one on both ends. I've spent some time testing it and we're still off a tad. I need to display Sunday through Saturday. I tested it with a variety of…

inNeed formula to pull data from Last week Sun through Sat Comment bylaura.buchanan 08/06/20

OK, we're ALMOST there. I really really appreciate your help. I have completed a bunch of formulas for a lot of criteria for two people to test it. We need to shift back by one day. The current formula captures last Monday through Sunday. We need to shift it by one day and display Sunday through Saturday. I don't…

inNeed formula to pull data from Last week Sun through Sat Comment bylaura.buchanan 08/05/20

laura.buchanan✭✭✭✭

Comments