Best Of
-
Re: Automation - Is it possible to re-send an approval workflow?
@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)1 -
Re: Populate Drop Downs Boxes from Column
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)1 -
Re: Report filter on Parent Data, but also return the Children for each returned Parent row
Yes. Whatever data you want to filter by needs to be on every row you want included. (View Post)1 -
Re: Stoplight for Project plan tasks
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)1 -
Re: Conditional formatting or restriction in format for forms
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)1 -
Re: What is the correct syntax for includeAll=true when pulling a report from the API?
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)1 -
Re: Workflow to Automate Document Generation?
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)1 -
Re: Some type of look up formula needed
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)1 -
Re: Automatically update a date cell to today's date based on a different cell value
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)1 -
Re: Help with SUMIFS formula
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)1