-
How to make synchronized dropdowns?
I would like to learn how to insert in my forms a dropdowns synchronized with a column from other page. It would resolve a lot of mistakes introduced in the forms. Thank you!
-
Problem with Health Column Summary Formula
Hi all, I have a formula counting a task's health based on status. I am now trying to summarize those results in a summary task@row using this formula =IF(AND(COUNTIF(CHILDREN(), "Red") >= COUNTIF(CHILDREN(), "Yellow"), COUNTIF(CHILDREN(), "Red") >= COUNTIF(CHILDREN(), "Green")), "Red", IF(AND(COUNTIF(CHILDREN(), "Yellow")…
-
INDEX MATCH Question
Hi everyone, I need a quick hand with an INDEX MATCH formula. I have a form that has users select their store from a drop down. I have two formula columns that use this entry: Region and then Regional Sales Director (RSD). I need to pull Region and RSD from a separate sheet that I don't manage. The column layout is shown…
-
SUM with multiple conditions
Hello Smartsheet Community, Can someone please help me on this. I am trying to get the sum of the entire column from the cross reference sheet and the formula =SUM({Sheet Name Range1},[Primary Column]10) is working fine as of now but I want to add 3 more conditions to meet before getting the total value from the Sheet Name…
-
Currency Symbols in SUM Formula
Hi I am using the SUM formula to total a column cost in my sheet summary. How do I get the £ symbol to show in the sheet summary field so, that when I pull it onto my dashboard it display as a currency figure rather than a random number? I know it's going to end up being something super simple! 🤔
-
Help with the count function
I'm reaching out to the community for assistance with the count function. I'm trying to count every time a line is tagged with the phrase RRB in a column called DLM Type. The formula I'm using is as follows =COUNTIFS(DLM Type:DLM Type, Find("RRB",@cell)>0) Everything I try returns me #UNPARSEABLE. THANKS !!!!
-
Overtyping a formulas answer
I need to automatically calculate a number in one column based on another column, but also need the ability to overrule this result at times and manually enter an answer in the "calculated" column. When I do I don't want to change the column formula to a line formula as multiple lines are continually being added and things…
-
Hide the rows with error without blocking the calculation
Hi Guys, I have a scenario here. I need to refer another sheet and I have to skip the count when the cell have any error. How should I perform that in smartsheet. Can anyone help with this one? With Regard lepote Jo
-
Line Chart - Sheet Structure for multiple values
Hi All I've searched for a solution but again, being so used to just being able to select columns and rows in spreadsheet apps I'm really struggling with creating a line chart which has several columns of data I need to turn into a single visual for my dashboard I want to show the number of tasks raised by MONTH for each…
-
Very Simple MONTH Function
Hi All I know this seems like a waste of a question but I really don't understand why the MONTH function doesn't work My month is formatted to UK DD/MM/YYYY and I have entered =MONTH([Month]) and it doesn't work and either shows INVALID DATA TYPE or INPARSEABLE Yep, I know, should be simple but for me... it's not Thanks…