Hi guys,
I use AppSheet to manage leads. I have created a system where a user can see details of the lead such as start date/month, location, contact number, comments, next follow up date and few more options. What i have done is that the user can select a future date in next follow up date tab and that lead will show in a section called Today's Follow up on that particular date. Attaching screenshots below
What i want is to create something so that in case the user is not able to move all the leads which are showing in today's follow up section for today to a future date then all these leads should be automatically shifted to next day. Will this be done with help of a bot or something else. I have no clue kindly assist here. If more info or screenshots are required please let me know.
Here's a technique.
AND([Next Follow Up Date] < TODAY(), [Lead Status] = "Follow Up")
).TODAY()
or TODAY() + 1)
).Hi,
Thanks for this. I will try to implement but i am very novice. Also want to ask is that instead of creating a button that moves all the leads tomorrow can't we set something to automate this task say at 11.59 pm so that all the missed leads for today automatically shifts to tomorrow in next follow up date.
@Ketan_Dogra wrote:
i am very novice
@Ketan_Dogra wrote:
set something to automate this task say at 11.59 pm
Hi,
i am not able to implement this.
Did you try and encounter a specific challenge?
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |