Is there a way to automatically add an entry on a monthly basis?

Bret Linford · 02/14/19

Hi, all.

I have recurring expenses monthly and it would be cool if I could have a new entry appear every month. Is there a way to do this? Thanks!

Andrée Starå · 02/14/19

Hi Bret,

Is it the same amount each month or do you want to add different ones each month?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Bret Linford · 02/14/19

Hi, Andrée.

Yes, same amount each month. ?

Andrée Starå · 02/14/19

Thanks!

Yes, it's probably possible.

Can you tell me more how it should work so I can get a better understanding of what you want to accomplish?

Best,

Andrée

Bret Linford · 02/14/19

I have a list of departmental expenses that I keep track of. I upload a pdf of the individual expense to a new line on the sheet. Each line has the pdf, the date, description, price, comments. I would like all of that info (except the pdf) auto-added to a new line on a specific date every month. Then I can manually attach the pdf receipt. Thanks!

Capto_Capture 2019-02-14_02-34-02_PM.jpg

Andrée Starå · 02/14/19

Thanks!

Could you share the sheet or a copy of it and remove any sensitive information?

Best,

Andrée

Bret Linford · 02/14/19

https://app.smartsheet.com/sheets/pHmVPHWX4hxmVvHvWgR6Rmvg5vhQCfc4chCJQJ21

Andrée Starå · 02/27/19

Hi Bret,

I'm glad we got a working solution set up.

Best,

Andrée

Aura Stewart · 12/02/19

How did you resolve that? I have a similar need. I manually add the same line of content to a specific SmartSheet once a month. I would like to automate that task. Thank you in advance for your assistance.

Andrée Starå · 12/03/19

Hi Aura,

There are a few different ways to structure a solution.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Is there a way to automatically add an entry on a monthly basis?

Comments

Categories