-
Auto Delete rows
HI, I would like to know please what will be the best way to delete rows which their time stamp i more than 24 hours. i can't find a delete function under the conditionl function.
-
How to identify the first date and last date from another smartsheet column?
I need to identify the following: Smartsheet 1, Column Start Date, row 1 cell 1 and Column End Date, row 1 cell 2 (need to obtain from smartsheet 2) Smartsheet 2, Column Start Date and Column End Date have several dates. Smartsheet 1 needs to identify the earliest Start Date and the latest End Date from these two columns…
-
RYG Arrow Colors
I would like to recommend an additional option to swap the red and green arrows so that there is an option for red arrow = up and green arrow = down. This is helpful for budgeting in project management where at a quick glance you can see if we saved money on an item or lost money.
-
How to check if Flag has been flagged in another sheet? Formula?
I have a metadata sheet that has At Risk row with a flag symbol, and I would like to check the other project sheet with an At risk column to see if any flag has been marked in that column. If any task has been marked in the project sheet, I would like the flag symbol in Metadata to turn red as well.
-
Check a Date Range
I need help with defining a formula to evaluate a date. I have a “Date” column which contains a mm/dd/yy date. I want to evaluate that column to return “Yes” if the date is within the current month and the next 60 days. For example: “Date” = 07/10/22 Today’s Date = 07/22/22 Is the “Date” within the range: 07/01/22 –…
-
Join columns from 1 match
Good evening, I'm looking for some assistance :) I've been trying to find the formula that alows me to join 3 columns value of the same line of the match. This is between 2 smartsheets. I made a quick draw of it. I would appreciate any help :)
-
Why HttpClientException is thrown from time to time while using Proxy?
Hi, When I'm using a proxy, I experience a bug that is not always reproducible: HttpClientException is thrown while calling ObtainNewToken from OAuthFlow. AutherizationResult parameter that is sent is always the same. Exception is thrown with message: "There was an issue connecting." Please help in finding a solution.…
-
Count distinct values within cell
a
-
Is it possible to set up a recurring update request that keeps sending until all cells are updated
Hello, I've set up a sustainability tracker for a team at my organisation and they are hoping to limit who access to it, whilst still wanting input from certain collaborators. My idea to achieve this would be using an automated workflow - namely an update request. I'm wondering if it is possible to set up the update…
-
How can I remove direct access to a Sheet, but still allow editing via Report?
TL:DR We are looking for a way to change/break the url to an existing Sheet (340+ columns) without breaking the connection to hundreds of Reports, thus preventing direct access to a Sheet people already have the secure link to, while still allowing view/edit access to the data via Reports. We've considered some options…
