-
Receiving an error message when trying to edit/save automations created by someone else
We are having issues editing automations that have been created by someone else. If someone other than the original person who created the automation goes in to try and edit & save they receive the error message saying "sorry, we are having trouble reaching Smartsheet right now....." The person who created the automationโฆ
-
=COUNTIF error
Hi there, I have some survey results on one sheet that I'm trying to pull into another sheet so I can build charts in a dashboard to display the trend in responses (i.e. how did people respond to question 1, question 2, etc. for each event). The survey includes a drop down to select the event the respondent participated inโฆ
-
#INVALID OPERATION is trying to break me
This formula is wrecking my day so I am waving the white flag and asking for help... I am attempting to display the LOG 2 "Title Company" where the LOG 1 FC Start Date (020) .GT/ET. the LOG 2 "Effective Date" and LOG 1 FC Start Date (020) .LT/ET. the LOG 2 "End Date" and LOG 1 "Property State" = LOG 2 "Property State".โฆ
-
Using INDEX function with Multi Select Columns
Greetings, I have been poking at this for a few weeks now, and I can't imagine that this is as complicated as I am making it. Below is an overly basic version of what I need to build. The left (tan) columns represent a sheet that managers update to request eLearning for their units (Care-Areas) and the right (blue) columnsโฆ
-
Trying to create a formulated/formatted sheet from the inputs of online Form
Hello. I am stuck here. I created a form. In the sheet file, Iย have some formatting and formulas to run reports based on the inputs coming from the online form. However, when a new input comes into the sheet as a new row, my formats and formulas that I set up in upper rows do not apply to this newly created one!.ย I have toโฆ
-
Need a check mark for rows added last month
I want a checkmark to appear when entries were created the previous month. i.e., all April entries would have a checkmark, and starting June 1, only May entries, and so on. I thought the following formula was a good place to begin, but apparently the -1 is only subtracting a day, not a month. =IF(MONTH([Entry Date]@row) =โฆ
-
Column formula - for increasing same value in array
Hi, I would like to see if it is possible to change the below FirstInstance formula into a column formula as I am using Data Shuttle to import new/revised data into the grid. FirstInstance Formula: =COUNTIF([Request Id]$1:[Request Id]1, [Request Id]1 = [Request Id]@row) + 0 DaystoClose2 col Formula: =IF(FirstInstance@row =โฆ
-
RYG Balls in IF(AND Formula
I am trying to automate the RYG balls to reflect a result based on up to two columns. All of the possibilities are: Green: [Expiration Date]97 is in the future or equal to TODAY Yellow: [Expiration Date]97 is within 30 days of TODAY Red: [Expiration Date]97 has already passed and [Renew] = "No" Related question: is itโฆ
-
using sum(collect()) with an or in the criterion range
Sheet A has three contact columns per row. Sheet B has a list of personnel. I'd like to collect the rows where a person appears in any of the three contact columns from Sheet A and sum on a numeric column My current solution is to write three sum(collects()) - one matching each contact column - and add the result. Is thereโฆ
-
Filter Helper Question
Hello, I am tracking communications for my project, and each row represents a communication (e.g., notify employees of changes to expense policy). I have separate date columns for "Draft Due" and "BU Review Due" and "Legal Review Due" and "Distribution Complete" (see attached). I want to have a filter to show me any rowsโฆ