Hi Smartsheet community! I realize there is a help area for this but I have looked ... read.. googled.. till I'm blue. So this is new and I thought in this NEW COMMUNITY maybe I could shout out for some help. I am trying to do a formula so that the smartsheet can look at a month ( column ) and then determine in another ( column ) the type of visit that's due based on that ( month ) ..
So to explain more.. I have been manually pulling down weither a client has a Routine visit due or a 6 Month visit due. On all 500 clients.. My hand hurts!
Is there a easier way?
Generally we put in the Start of care date.. and then from there we can determine in the ( OTHER ) column what type of visit on of my staff should be putting down. ( 6M or Routine ) this is getting tiresome. Is there not a formula that I can use? HELP!!!!