-
Hiding form drop downs based on prior submissions
I'm trying to mimic a Qualtrics survey capability that enables the survey (form) to only show available dates that have not already been selected by prior survey respondents. Is there a way to accomplish this?
-
Possible COLLECT or INDEX/MATCH IF between two sheets
Hi, I'm having difficulty figuring out a formula that references two different sheets. Any help would be much appreciated! Thank you! Below are screenshots of the two different sheets along with notes/explanations. Below is the text of the sheet names and fields for easy reference on formula ideas. That way you don't haveโฆ
-
Form AutoFill Send me a copy of my responses
I want to make sure a copy of all responses goes back to the person who filled out the form. I provided a link using "?ECA=name@domain.com". This works perfectly when the form is accessed from a laptop, but it does not work when they access if via their phone. Does anyone know why and if there is a way to ensure it isโฆ
-
Counting the number of projects started in a year
I'm trying to count the number of projects starting in a year. I am using the formula mentioned below - =COUNTIFS({Portfolio Roll-up - Start Date}, YEAR(@cell) = [Primary Column]@row) where Primary column has the number "2021". I am getting an error "#INVALID DATA TYPE". Both the columns (Primary and formula column), areโฆ
-
Cross Sheet Formula..
Hello! I am trying to build cross sheet reference that will tell me how many of a certain project are happening in a particular month.. However we had start and end dates we don't track anything by month. So my logic is =COUNTIFS({ Range 4}, "All Regions", {Range 1}, ="NAME", {Range 3}, >"Blue", {Range 5}, "BAU", {Rangeโฆ
-
"IF" formla and Red/Yellow/Green
I am putting together a sheet that will be used as a template. There are 3 columns (Date Assigned and Date Due and Status). Status states Complete, Not Complete, and Not Applicable. There is another column that has the Red/Yellow/Green bubbles that should automatically update (red if late, yellow if within the date range,โฆ
-
Conditional Formatting Based on Row Action Indicators
Does anyone know if it is possible to apply conditional formatting based on row action indicators? I would specifically like to increase the visibility of an overallocated resource on a sheet by turning the cell red. If conditional formatting cannot be applied based on the overallocation indicator directly, is there someโฆ
-
Highlight Weekend Dates
Hi, I am super new to smartsheet and still learning. I have no previous experience with formulas. I have a column that has dates in it, but I want them to highlight red or something if the date is a weekend. Is this possible? What would the formula be if it is? Thank you in advance for any help.
-
Auto fill Form
I have a form that I'm sending to users via email with a link. When they open that form, I'd like the date and name to auto-populate with the current date and their name. Information: The sheet that will be receiving this information could have their name in row 1 if that would help, but I don't want to already have rowsโฆ
-
Unparseable Error
Good morning, I'm new to Smartsheet. I'm getting an error when I add the following formula. I'm trying to get it to return the current project phase that is less than 100%. Do you know what I'm doing wrong? =IF([% Complete]37<100%,[Task Name]37, [% Complete]54<100%,[Task Name]54, [% Complete]75<100%, [Task Name]75, [%โฆ