-
Project Management - IF(OR(AND())) - Formula Help
I've been working on this for some time and just can't seem to get it to work the way I need it to. I am attempting to build one sheet that will allow me to track the status of all the projects in my section, while also tracking the progress of tasks within each project, for both current and historical projects. I have…
-
Formula to check if cell contains a value from a range of cells
For example, the text in column 4 row 2 is "xxxxx_email address=test@test.com" * The text in column 2 row 11 is "google@google.com" * The text in column 3 row 11 is "1" * The text in column 2 row 12 is "test@test.com" * The text in column 3 row 12 is "2" * The text in column 2 row 13 is "smartsheet@smartsheet.com" * The…
-
Formula needed
I am trying to set up a formula that will subtract from a given value, each time that item is found. I have a form that my team will be using to enter data (item) and how much they found (subtract from value). In turn, I need to have a running total of what is still not reported for each item.
-
Formula to get data from current week only by day of the week.
I have a worksheet with case information and who these cases are assigned to. I am trying to add columns that will total the cases from each day of the current week. ex. columns with a total count for mondays cases, tuesdays cases etc. thru friday. This worksheet has data for the whole month and all I need is the current…
-
Regular Expressions (RegEx) with FIND function
Hi Team, I'm guessing that SmartSheet doesn't support regex in formulas as I get an #UNPARSEABLE error when I try it but I thought I'd better post the question here before I make that assumption. I have the following text in my "Subject" column: [1751] - Guide Posts With the formula: =MID(Subject1, FIND("[", Subject1) + 1,…
-
Filtering out data from an equation
Hello, Is there a way to filter out specific data items from an equation? Specifically I am creating a sumifs formula and I would like to be able to filter out fiscal year data without making it a condition of the formula, that way we wont have to change the formula every year. I have a column that shows the fiscal year as…
-
Formula to Ignore a N/A if selected from a dropdown, and not break the rest of the formula
I need to add another scenario to one of y formulas, If one of the departments does not have to approve a certain type of change, they will choose N/A from the drop-down. So I will need the Approval Status column to IGNORE the N/A in that row. So if only 3 people needed to approve it choosing then the non approvers choose…
-
Formula to create a Symbol response based upon a text string in the Comment
I am attaching from my emails a specific email response to the comments. The email will always have the same email the address is from. I would like to create a column using a symbol and say..... If the following text string is listed in any comment related to that record and to show a green dot.
-
How do I autofill a formula to new rows that will be added via a web form?
Hi, I'm trying to have a formula autofill as new rows are entered into a project list sheet. I know smartsheet has an autofill formula feature, but I'm not sure how to use it. Is it an automatic thing by default, because if that's so, my formulas from the rows above are not autofilling in new rows created. Any help…
-
Sum every other row
How do I add up values of all odd or all even rows? I've tried =SUMWIN(WIN1:WIN119,MOD(ROW(WIN1:WIN119)+1,2)) but it didn't work (WIN is the title of the column)