Sign in to join the conversation:
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!
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
Hi, Andrée.
Yes, same amount each month. ?
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?
Andrée
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!
Could you share the sheet or a copy of it and remove any sensitive information?
https://app.smartsheet.com/sheets/pHmVPHWX4hxmVvHvWgR6Rmvg5vhQCfc4chCJQJ21
I'm glad we got a working solution set up.
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.
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!
Workflow Consultant / CEO @ WORK BOLD
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
