Welcome!

Auto Fill Date every 30 Days

Good Day All:

Is there a way to Auto-fill dates? For example:

04/30/18

05/31/18

06/29/18

Thanks

Formulas

You could create the first date in the row... then in the 2nd row add this formula in the date column =[date column name]1 + 30

That will calculate your 2nd date, then you can drag down the bottom-right corner to populate the rest of the dates.

Do note that if that first date disappears or changes it will affect the rest of the dates.

Got it, Thanks!

You're welcome! Glad I could assist.

Workaround for =HYPERLINK
Each row has a unique ID and I use this to generate two different hyperlinks in excel with this =HYPERLINK(CONCAT("http://www.XXXXX/",A3),"URL") Is there a workaround in Smartsheets to do similar?
Set a value on one sheet if that sheet's row ID exists on another sheet with a certain status
I have Idea IDs that appear on two different sheets (sheet A, sheet B), and I have a column on sheet B called "Update needed?" Sheet A also has an Idea status column. I need a column formula for sheet B's "update needed" to be set to Yes if sheet A's Idea ID=sheet B's Idea ID for that row AND sheet A's status is "Not…
Range settings
=SUMIF({Stores Daily Log Range 8}, "1000000456", {Stores Daily Log Range 9}) Hi I am adding figures from the above sheet to another sheet using criterias. everything works until I add another line in the log then the Range does not automatically pick up the new line. Is there a way to do this please.