-
Formula for automatically pulling rows of data from one sheet to another using checkbox
Help please 🙏 I need a formula or solution for automatically pulling rows of data from one sheet to another using a checkbox... So sheet A has a ticked checkbox, meaning I need the information from most columns in the ticked rows moving over sheet B every time a sheet A checkbox has been ticked.... (I need name about 5…
-
Nested formula with sheet references help
I need a formula that will: look up a name listed on sheet #1 on Sheet #2 and pull the most recent date they completed training. So far I have tried two formula combinations and neither has worked. =IF({Training Data Range 1 - Name} = Name@row, MAX({Training Data Range 2 - Date})) #INVALID OPERATION =VLOOKUP(Name@row,…
-
how do I convert email addresses to only names under Owner field ?
The Owner field in my Smartsheet I inherited from another user contains a mix of names and emails. When I execute the drop-down under Owner, the names entered in my Smartsheet Contact list are not visible, only the associated email. My preference is to list only the names, not the email addresses, in the Owner field.…
-
Formula referencing another worksheet
Hi, I am trying to create a formula to determine how many tickets are in a Category and have a due date within the next 30 days. I am trying to do this outside of the worksheet so when creating my formula I need to reference back to this sheet, however no matter what I try I'm still having the same issues...…
-
Formula returning a negative number when a zero is expected.
Hi Smartsheet Community, Probably something easy I'm missing but it's escaping me. I am looking to have the total number of work orders broken out into number of work orders to be completed per month during the contract start and end dates. Currently the formula is returning a negative number or a number in a month column…
-
Counting Multiple Symbols
Hello! I have tried COUNTIF and COUNTIFS trying to get the count of "Yellow" and "Red" symbols. I'm using Green, Yellow, and Red. Is there a formula that will populate the total of the Yellow and Red within a single column?
-
MODE Function
Is there a function within smartsheets that mimics the MODE function in excel? Looking to find the most occurring text within a column.
-
Week Of Date Formula ( Week of 2/6)
I want to be able to filter all the jobs per the week; Week of function. Example: Week of 2/6 would automate for any jobs that has a start date between 2/6 and 2/12) In excel the formula was =IF(G12<G12-WEEKDAY(G12-1),G12,G12-WEEKDAY(G12+7)+1). How do i convert that to a Smartsheet formula? (G12 in Smartsheet is _Project…
-
Formula went in to invalid operation when updating date range
Not sure what i accidently changed. please help i am not seeing my mistake. =COUNTIFS({Behavior Based Safety Observation Range 1}, IFERROR((@cell), 0), >=DATE(2022, 1, 1), {Behavior Based Safety Observation Range 1}, IFERROR((@cell), 0), <=DATE(2022, 1, 31), {Behavior Based Safety Observation Range 3}, "approved")
-
count check box
=COUNTIFS({MASTER - Material Requisition & PO Range 3}, "true", {MASTER - Material Requisition & PO Range 2}, [Assigned to]@row) What am I doing wrong? I want to count the cell if the cell is checked