-
Issues with Countif and HAS formula
Hi Smartsheets, I am trying to understand how many projects received were made in active each month. The column indicating the month is was made inactive has two lines of content, so the formula require a HAS @Cell. Also cross referencing a difference sheet. The formula I am currently trying is: =COUNTIF({other sheetβ¦
-
COUNTIF and...
=COUNTIF({Template -Tasks Range 1 - Due Date}, <=TODAY(7) I have this working, however how do I addΒ Only ifΒ the Status column from origin sheet is not complete? I've tried variations around this... =COUNTIF({Template -Tasks Range 1 - Due Date}, <=TODAY(7), {Tasks Range 1 - Status}, <>Complete)
-
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 !!!!
-
Calculating markups for multiple value ranges in a single formula in Excel/Sheets
Hello! I'm a relative newcomer to spreadsheet formulas. I'm trying to use one formula to create standard markups for items based on fixed cost ranges. I thought I figured out how to use greater and less than in a formula and how to nest them together for multiple values and calculations, but instead of getting a markupβ¦
-
Populating a Date field using formulas
Hi All, I have 2 known variables that I want to use to populate a Date field: We know the date that a Learner starts a course [Start_Date], and we know the cadence at which a report should be pulled afterward [Report_Cadence] (sometimes in weeks, sometimes in weeks + days). I am having trouble creating a formal that willβ¦
-
IF {NAME} in List Than "YES", "NO"
Hello smartsheet Community, I have to lists: list: everyone can put his information on it list: is a contact list which shows special persons I want to put a column in the first list, which says, if the submitter is a part of the 2nd list. I tried it with IF- and INDEX-formular, but its not working. about your help I wouldβ¦
-
Reset Auto numbering using Automation
I'm using a form to captur data in a smartsheet and I need the auto numbering to reset annually. Deleting the column manually isn't an option since I can't delete the data in the current sheet and also the column is used in equiations in other columns. Any advice?
-
Re-uploading of attachments through forms and document control
Hi, my team uses a smartsheet form as an internal review process and uploads the PDF through the form for review, it is then either accepted, or declined whereby the reviewer would attach the file with REVEWL1-DOCNAME through the form. The author can then download the PDF and action the modifications to the document basedβ¦
-
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! π€
-
Flagging a row based on it being the original entry
I have a sheet that is populated through a form. My employees look at many files a day and some are duplicates from the same day, previous days, weeks, or months. I want only the original file to count in my tally, so I am trying to build a formula that will automatically mark or flag the subsequent file(s) as duplicateβ¦