@Traci Summers I figured out a workaround by manually changing the approval status column in the sheet from Submitted to Approved, which then triggers automation to go to the next approval step. I ha… (View Post)

Hi @APS I hope you're well and safe! I recently developed a solution for a client where the Dropdown lists are kept updated using the premium app, Data Shuttle. Is that an option? I hope that helps! … (View Post)

Yes. Whatever data you want to filter by needs to be on every row you want included. (View Post)

Hi @bct You're close! Since you already state certain requirements (such as % Complete = 1) then we don't need to state the opposite in later requirements. For example: =IF([%Complete]@row = 1, "… (View Post)

Hi @LJK I hope you're well and safe! To add to Mike's excellent advice/answer. Can you give an example of what you'd need to clean up? At a glance, it seems pretty straightforward to maybe use four d… (View Post)

Hi @CycleBagEd The default Page Size (if not specified) is 100, and the maximum rows that a Get Report call can retrieve is 10,000 rows at a time, as you've found. Here's the information in our previ… (View Post)

Update - I've heard from our customer success manager that Smartsheet is working on a workflow that will enable you to automate document generation. Fingers-crossed! They are hoping to launch in June… (View Post)

Hey @Micah Turner I would recommend an Index/Match for the lookup. For this specific instance, the formula below should work =INDEX({Project Intake Sheet Project Manager column}, MATCH([Job Number]@r… (View Post)

Have you tried an IF function? In the date column where you want today's date, did you try =IF([email protected]="Your Value",TODAY()) (View Post)

Say you want the expenses dated in May, Try this: =SUMIFS({Expense Tracker Amount}, {Expense Tracker Job #}, [Job #]@row, {New range to your date column}, MONTH(@cell) = 5) (View Post)