# User specific data using a date formula in google sheet, input in glide **URL:** \ **Category:** Ask for Help\ **Created:** [February 14, 2023, 2:20pm UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939 "2023-02-14T14:20:28Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![Joe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe/32/54373_2.png) [@Joe](https://community.glideapps.com/u/Joe)\ **Post date:** [February 14, 2023, 2:20pm UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/1 "2023-02-14T14:20:29Z")
Hi , I’ve built an app using google sheets template and I have date formulas in google that automatically fill in but need to be user specific. So it’s a checklist with a completed date (user inputs via a date box on glide) Then it spits out the next due date and supposed to populate on the glide app. The google formula is if completed then adds frequency (weekly or monthly or annually ) to determine the next date. I see it under my admin but is this being done right to be user specific? I have multiple tab for these tasks (each grouping of tasks has its own tab) And user profile tab I use row owner for email. Am I doing this the right way? When I tried to make user specific columns in glide for the dates the next due wouldn’t work for other profiles other than mine Thanks! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 14, 2023, 3:12pm UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/2 "2023-02-14T15:12:04Z")
Can you add a screen shot or two from the Glide Data Editor that shows how you currently have your tables structured? The formula you mention would probably be better if done with Date Math in the data editor. ---
**Author:** ![Joe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe/32/54373_2.png) [@Joe](https://community.glideapps.com/u/Joe)\ **Post date:** [February 14, 2023, 6:37pm UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/3 "2023-02-14T18:37:01Z")
Thanks. Here is excel screen shot. I’m not at my computer so can’t access the data editor to show that set up. User inputs completed and then that feeds next scheduled (completed + frequency). Will this be user specific or will they overwrite each other? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/8/487773af4c1fb4e52d6d7bb5c105513652df18fb.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 14, 2023, 11:37pm UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/4 "2023-02-14T23:37:48Z")
Glide will see your results as non user-specific and I assume that’s not what you want. > [@Joe](#): > > So it’s a checklist with a completed date (user inputs via a date box on glide) I think what you can do is add a user-specific completion date column, then use the Math column of Glide to derive the “Next Scheduled” date. How you get that formula to work will be the main problem. I assume next week means 7 days after the completion date, next month means the same day of next month after the completion date (this is a bit tricky), and next year means the same day of next year? ---
**Author:** ![Joe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe/32/54373_2.png) [@Joe](https://community.glideapps.com/u/Joe)\ **Post date:** [February 15, 2023, 1:11am UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/5 "2023-02-15T01:11:01Z")
![Screen Shot 2023-02-14 at 8.06.10 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/0/a0885cb60d8a854f782b46f3c9fa18f4f7c0759a.jpeg) In the photo, i have both the google sheets tabs (which work for just me), and also the user-specific glide data columns (next due and completed to the right of it) The user data column works when i view as myself, but when I view as anyone or a made up user it doesn’t auto-populate the Next Due date. I used the math function and i used the frequency column in days (math: completed+frequency) ---
**Author:** ![Joe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe/32/54373_2.png) [@Joe](https://community.glideapps.com/u/Joe)\ **Post date:** [February 15, 2023, 1:15am UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/6 "2023-02-15T01:15:25Z")
If i left the google sheets as is (without the data editor glide columns) having the user profile tab with a row owner by email and each row here having it’s own ID, SHOULD IT technically work with each user being specific? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 15, 2023, 1:19am UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/7 "2023-02-15T01:19:56Z")
Why is the Frequency Days column user specific? It seems to me it shouldn’t be, unless you define a month/year/quarter/etc differently for each user. Do users enter their own values for this column? ---
**Author:** ![Joe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe/32/54373_2.png) [@Joe](https://community.glideapps.com/u/Joe)\ **Post date:** [February 15, 2023, 1:40am UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/8 "2023-02-15T01:40:21Z")
the frequency day isn’t; just the completed and next scheduled are. I saw i deleted that; but the user-specific “next due” doesn’t show up as a data option for the column of “next scheduled”. it only allows me the google sheets choice; BUT if I clear the date (and have the next due as a placeholder) it then defaults to the correct next scheduled date since it points to the placeholder. It also works in the “fields” display and lets me use it as a data option as well as an option to show in the main collection. I just can’t get it to show as data for the button in the details page. ---
**Author:** ![Joe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe/32/54373_2.png) [@Joe](https://community.glideapps.com/u/Joe)\ **Post date:** [February 15, 2023, 1:43am UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/9 "2023-02-15T01:43:02Z")
![Screen Shot 2023-02-14 at 8.42.31 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/02851caf822a3cf72c2fd1bba5b0f3b0c8057251.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 15, 2023, 1:49am UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/10 "2023-02-15T01:49:21Z")
> [@Joe](#): > > the frequency day isn’t; Yes, it is. ![CleanShot 2023-02-15 at 09.43.48@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/7/07e6cfef75749475c5fe3e3aeb1587fb93b8cefe.png) > [@Joe](#): > > but the user-specific “next due” That’s not user specific, it’s a computed column which may or may not effectively be user specific depending on the input data. > [@Joe](#): > > it only allows me the google sheets choice; BUT if I clear the date it then defaults to the correct next scheduled date. It also works in the “fields” display as well as an option to show in the main collection. I just can’t get it to show as data for the button. Not entirely clear what you are trying to do here. What button? What does the button do? ---
**Author:** ![Joe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe/32/54373_2.png) [@Joe](https://community.glideapps.com/u/Joe)\ **Post date:** [February 15, 2023, 1:50am UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/11 "2023-02-15T01:50:28Z")
thanks, i meant it isn’t supposed to be and corrected it when you pointed it out. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 15, 2023, 1:53am UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/12 "2023-02-15T01:53:13Z")
Okay, so where does that leave you now - what isn’t working? You mentioned something about a button. Please elaborate… ---
**Author:** ![Joe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe/32/54373_2.png) [@Joe](https://community.glideapps.com/u/Joe)\ **Post date:** [February 15, 2023, 2:16am UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/13 "2023-02-15T02:16:17Z")
Ok, what you said makes sense that it’s not user specific and auto-generates so the user will see that based on their completed date input. however, even the new data column that’s not user specific doesn’t show up as an option for Data. sorry - i mispoke, not a button, a date entry the Data field doesn’t allow the new math column to show ![Screen Shot 2023-02-14 at 8.58.28 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/1056dc008369bb55a128eec53bcdb5db9e97669e.png) I think i found a workaround by removing the “date” component and replacing it with a field component. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 15, 2023, 2:24am UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/14 "2023-02-15T02:24:34Z")
What you are showing there is a pair of DatePickers. DatePickers are input components, and input components cannot write data into computed columns. That is why you cannot select the math column. So yes, if you just want to display the value in that math column on the screen, then you need to use a non-input component, such as a field or text component. ---
**Author:** ![Joe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe/32/54373_2.png) [@Joe](https://community.glideapps.com/u/Joe)\ **Post date:** [February 15, 2023, 2:33am UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/15 "2023-02-15T02:33:10Z")
many thanks for your help on this Darren! Quick question: How can i clean up columns? Some won’t let me delete; not a big deal, just don’t know if i should leave it or create a whole new sheet. once i complete the user profile and contacts tabs and figure out relations + lookups and groups i’m sure i’ll just want to redo the whole thing lol. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 15, 2023, 2:45am UTC](https://community.glideapps.com/t/user-specific-data-using-a-date-formula-in-google-sheet-input-in-glide/57939/16 "2023-02-15T02:45:13Z")
> [@Joe](#): > > Quick question: How can i clean up columns? Some won’t let me delete; not a big deal, just don’t know if i should leave it or create a whole new sheet. For non-computed columns that are attached to an external data source (ie. Google Sheet), you need to delete them at the source. So in your case, delete them in the Google Sheet. Be sure to check they aren’t used anywhere first with the “Find All Uses” option. > **[Introduction to the Data Editor | Glide Docs](https://www.glideapps.com/docs/getting-started/introduction-to-the-data-editor)** > > The Data Editor is where you manage your app's data.