-
'Receive Copy of Form via Email' Checkbox: Default to Checked?
Good morning and hoping for help on a quick question, re: the feature to include a 'Receive a Copy of Your Submission via Email' checkbox at the end of a form. My team and I are designing forms to gather information from our end users, and would like to use a 'Receive a Copy' checkbox at the end of each form, to enable…
-
Returning Task Name based on a minimum number in Helper that is >0
I have previously asked a similar question, but with fewer requirements. I am trying to return the Task Name associated with the lowest number in a helper column that is >0. With some help from L@123, I was able to get close, I think, except the following code returns a zero, and there are no zeros in CHILDREN([Task…
-
why does smartsheets not Sum Cells with leading zero values
I am trying to do a =SUMIF into a sheet via cross reference (=SUMIF({Mth/Yr}, ={Prev Yr Mth/Yr}, {DofC NN.NN})) Mth/Yr = 9-2019 Prev Yr Mth/Yr = 9/2019 DofC NN.NN contains rows that have a value with 0.nn (nn = 01 thru 99) The result from the SUMIF is 0 (zero) Does SS not add values with leading zeros? What am I doing…
-
Is it possible to apply Conditional Formatting with a formula?
In Excel we have the ability to use custom formula for conditional formatting, is this possible in SS? Please see screenshot below. I need to compare column values to the value at the top cell. I can do this by adding more columns and formulas and then hide them, it would be cleaner if I can do with conditional formatting.…
-
Formula to Automate Stage
Hello - I am trying to figure out if there is a way to automate the selection of one of three stages (Not Started, In Progress, Completed) based on Start and Due date columns. Activities with a Start Date in the future would be 'Not Started', activities with a Due Date in the past would be 'Completed' and anything with a…
-
AVG(Collect) Formula help with date range
Is there a way I can give a date range in the formula below so that it averages between dates 8/21/19 - 10/29/19 =AVG(COLLECT({Nexus Dependencies Range 5}, {Nexus Dependencies Range 1}, "The Scrum Lords", {Nexus Dependencies Range 3}, DATE(2019, 10, 29)))
-
Formula issue for conditional formatting
I am trying to set up a formula to allow for conditional formatting but having some problems. This is the formula I'm trying: =IF([Actual]19 >= [Target]19, IF([Actual]19 < SUM([Target]19 * 0.1), IF([Actual]19 > SUM([Target]19 * 0.1), "GREEN", "AMBER", "RED")) but the result leaves the cell blank with no error message. What…
-
Retrieve most recent values in multi-select column using formulas
I am struggling to get the formulas to retrieve a value in a multi-select cell. For example: Flavor options in multi-select dropdown: Vanilla, Chocolate, Mint Flavor1: Vanilla (row 1) Flavor2: Vanilla, Chocolate (row 2) Flavor3; Vanilla, Chocolate, Mint (row 3) In a separate column I want to use a formula to retrieve the…
-
Formula Help!!!
I'm having issues with making this formula work for the RYGB Balls. Any glaring mistakes? -Green – An open request that was received 1-5 days ago. -Yellow – An open request that was received 6-10 days ago. -Red – An open request that was received more than 10 days ago. -Blue - Complete -Blank/No Date - Blank status…
-
Calculate Date Employee turns 18
Can anyone provide a formula that calculates when an employee turns 18, based on a DOB (date of birth) cell. I've reviewed the forum and found formulas that return an age, but we need a date so we can set up a notifier email to alert payroll for some HR requirements.
