-
Adding attachments to a row in Smartsheet using a HTTP action in Power Automate
I am trying to upload attachments to a Smartsheet row using the HTTP action in Power Automate. Is this possible? The URI is accurate (populated by dynamic content in the flow). I am receiving this error: "Multipart upload request was invalid. Please check your request headers and payload." Does anyone have advice? Thanks!…
-
Create a Filter by Keyword for most frequently used criteria
Dear Community, Filters in Smartsheet are great, but I am looking for a solution to create a filter by keyword, where a user could paste the most frequently used value (i.e order number) in just one click. Think of MS Planner filter or a solution in the old Access. Please point me in the right direction.
-
Rolling Calendar Visual
After a few different approaches, I was able to put together a set of metrics using various formulas and corresponding visual for a rolling 12 month calendar based on the underlying data set. The data set spans across multiple years and I wanted to create a rolling calendar that always displayed the most recent 12 months,…
-
How would I add a MAX function to COUNTIFS formula?
ISSUE 1: I have a formula I'm using to update a radio button called "Paused" to identify items in another sheet that are paused. I need to make sure it looks at the most recent occurrence of the item in the list using the last run date. How would I add a MAX function to this formula using the last run date.…
-
How can I get this formula to return a value when two criteria are met?
Initially, I used the formula below to return the Payment Term value from my Contract & Exhibit Tracker where the vendor #s match between my source sheet and output sheet. And it worked. =IF(ISBLANK([Vendor #]@row), "No Match Found", IFERROR(INDEX({Contract & Exhibit Tracker - Payment Terms}, MATCH([Vendor #]@row,…
-
COUNTIF reference not working
I have a time entry on one sheet where times are entered in the HH:MM (24 hr) format and another column that pulls the hour of that day. [Time Received (FORM)] - time in HH:MM format [Received Hour of Day] - pulls the hour of the day with the following formula: =IFERROR(LEFT([Time Received (FORM)]@row, FIND(":", [Time…
-
Search Box For Dynamic View
A search box would be super helpful on the Dynamic Views. The ctrl+f function works but only on the page currently in view. If you have data further down the page, there is no way to find that data using the search function. We are having to create a filter and update it with the new criteria every time we have to search…
-
Workspace tags or formatting
I would like to be able to sort or tag or otherwise format my workspaces in the browse view. I've got several different projects going on and it would be helpful to my brain to visually sort them. Something like this: Or perhaps create higher level Workspaces to better sort projects? Just an idea. Thanks for considering.
-
Project Plan Backward Scheduling / Planning
Implementing backward scheduling in Smartsheet would significantly enhance its utility for project managers who work with fixed deadlines and need to calculate start dates based on a target completion date. Backward scheduling allows users to plan by defining end goals and identifying the necessary steps and timelines to…
-
Nested(?) If statements
Not sure if nested is the right term. I want the formula to show - If any of these columns (IT, SUS, HSE etc) have "Not Achieved" in them then look for the largest/ latest date from the columns IT comp. SUS Comp. HSE Comp. and display that date. Otherwise "Badges complete". The result column is a date column so not sure if…
