-
Countifs
Hello All, Maybe somebody could help me to set up formula where not blank cells would be counted. At the moment I am using this formula =COUNTIFS({Type1}; "SIS"; {Done1}; 0; (NOT(ISBLANK{Instaliacijos pradžia1}))). I've underlined part which is not working for me. I am bit weak with formulas so it might be what I wrote…
-
Formulas Referencing Another Sheet
Hi, am working from a running sheet that currently has formulas but I'm trying to put the formulas into separate sheets so I can run metrics in a slightly different way and try to make the running sheet more efficient. However, whenever I type the exact same formula, with the only difference being referencing another sheet…
-
Odd Behavior: New Blank Rows Created from Webform Entry
I'm wondering why the default behavior of a standard sheet is to create 10 to 50 new blank rows when a new webform entry is received. New blank sheets are created with 50 rows. If you delete 49 rows and generate a new row from a web form then the sheet will automatically create 48 blank rows to bring you back to the 50 row…
-
Automatic "Cell linking"
*What would be the best way to create a permanent link between cells. What I want is that if the user knows one of the bits of information, i.e. "WXP" that the other 3 cells get filled in automatically. We basically develop real estate and the project might start out known as the "Nome project" and gets assigned a Project…
-
Formula to automate Parent date
I can't seem to locate the formula that auto-fills a Parent date with the last date entered for a Child line item. It would be the same as the Start and End Date column parent cells, but those are system so I can't copy/paste the correct formula. EXAMPLE Parent Date | =last date entered below Child Date 1 | 1/3/17 Child…
-
Countif lookup by email/contact
Hello - I have a sheet ("Sheet 1") where users enter various entries/plans, etc. via a form and to associate it with themselves, I have them use their email address which logs into a contact column. In another sheet ("Sheet 2")- I have a list of everyone who is expected to put in information. I have a contact column with…
-
#INVALID DATA TYPE with a VLOOKUP formula
I need to turn a column of dates into two additional columns, one with the month name and one with the year. The year was easy. But when using the MONTH formula, it returns the month as a number, 1-12. No big deal; as a workaround, I set up a "helper table" in another sheet with the numbers 1-12 and their corresponding…
-
Test against Attachments column within formulas
How would I reference the Attachments column in writing a formula? For instance, if I want one column's text to display "Attached," on the condition that there are attachments to that row? Or if there are better ways to do it that would be great. I have a "Resource Locations" sheet. In each row there will be the name or…
-
Using If/Then Formula
I'm new to Smartsheet and have a drop down menu that needs to tie to another column/field I am trying to create a if/then formula but obviously I'm doing something wrong as I keep getting an #UNPARSEABLE error. I'm trying to say "if Industry Examinations equals Series 24, then add the description, and if not, then leave…
-
Help with #DIVIDE BY ZERO error message
Hello, Hoping you might be able to assist me with a similar issue I'm experiencing. I've attempted to import a Trello board into Smartsheet for one of my colleagues and I'm getting the same error message, when I view it in grid view on some of the rows. The formula in question that is currently being used…