-
Countif range from multi select contains (value) under each parent from another sheet
I need a cross reference formula using countif a specific value in a multi select column is under a parent from another sheet.
-
Autofill formulas not applying per conditions
I have two formulas in my sheet, one that populates with different symbols and one that triggers a checkbox. One formula is using reference to @row while the other is using a specific row number. The formulas are applied to all rows in their respective columns. Neither of the formulas is getting updated when a new row is…
-
Formula
Hello, Can someone help convert this excel formula to SS? =IF([DAY COUNTER]1 = "1", =TODAY(), IF([DAY COUNTER]1 = "2", =TODAY() + 1, IF([DAY COUNTER]1 = "3", =TODAY() + 2, [DAY COUNTER]1))) Expected result is to determine that 1 = current date, 2 = current date+1, 3= current date+2 I'm not sure if I'm explaining it…
-
SUMIFS Formula won't compile
Hey there community! I have been working on this formula for a few days now and it just won't fly. I think the "<>Closed" is what is throwing it off? I have tried all sorts of varieties of syntax (<>"Closed", =2019,="2019",) - and it wont fly. Here is what I have now. Please see screen shot as well. =SUMIFS([$USD - Sales…
-
Substitute Formula for random strings of phone numbers
We have a column for phone #s that is filled by our staff via a webform. As you can imagine, this leads to a lot of randomly formatted numbers. Ex. (555)555-5555 555-555-5555 555.555.5555 5555555555 I would like to construct a formula that will remove all the dashes, dots, spaces, parentheses, or even stray letters, to…
-
Auto-populating form fields
I'm working on a form right now and am having some issues that I'm hoping someone can help me with. I'm trying to develop a form that auto-populates specific fields. Something similar to the "request an update" feature, but in a form that I can edit the look and layout of. I've tried using a query string, but so far I…
-
What am i doing wrong
Need help with my formula why isnt it working?
-
Automating Day of the Week Lanes in Card view
Hi all, We're using Smartsheet to plan content development and scheduling for a radio station. We'd like to create lanes in the Card View for each day of the week (I already know how to do that part). But each row in grid view already has a broadcast date assigned to it, which of course feeds the Calendar view. I'd like to…
-
Formula to Count Data Broken Down by Month
I am wanting to use a formula to count data in various columns based on specific time period. Example for the month of October, I would like to count various column data and when it rolls into November I would like the formula to continue to work without changing it. I am able to use my formula (see below) to capture…
-
help with countIFS
I am using the following formula to count the total number of 100%'s in my range. it can count not blanks but doesnt count the total number of 100%'s. Can someone help me. what possibly is wrong in this formula? =COUNTIFS({Nexus Dependencies Range 5}, AND(NOT(ISBLANK(@cell)), @cell = 0.1), {Nexus Dependencies Range 1},…