-
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…
-
Trying to Flag Overlapped Participants in Meetings
So I am trying to find a way to flag if there are the same people in multiple meetings. I am working with a drop down type format for the list of participants, so I am not sure how or if there is a way to compare the individual entries of the drop down to other elements in the column to test for potential conflicts.
-
Flag warning if date is after another within same column
Hi all, Currently having issues with this: I need to find a way of flagging a warning (that'll just say "WARNING") in the thirteenth row of the date column if any of the dates in rows 2-12 are after the date in row 1. I am also struggling to find a concise way of flagging a warning in row 14 if there are any duplicates in…
-
Dependency with Teamworks
Hello! I'm new to Smartsheet and trying my best to learn so please be patient with me. We are a small company and are starting to properly organize our team using Smartsheet and TeamWork but we're running into a wall. My boss found out that if you link TeamWork together they both share co-dependence meaning that if you…
-
COUNTIFs across multiple columns from another sheet
Hi all, I'm currently struggling to execute a formula to count the number of times a contact appears across multiple columns from a sheet I'm referencing. I know I can just add two COUNTIFs statements for each column but this doesn't solve my problem of only wanting a contact to be contacted once for each row (eg if the…
