-
Current Week/Last Week
I want to be able to get a count of Issues Created, based on certain criteria, for both the current week and the week previous. I tried making things easy for myself and creating helper columns but those didn't seem to function, so I am here. I want to count the number of instances an issue was created if the branch and…
-
Referencing a not blank cell of 5 cells.
Hi, I am trying to populate a cell with data in 1 of 5 cells that are filled from a form. For example, using form logic of the organization that is selected (column Org Name) select the site from that Org (Org 1 and site 1) Each Org has its own list of sites in its respective column. I have tried using IF(ISBLANK(NOT( and…
-
Auto Populate from Forms
Hello everyone I have created a form to gather data, from there i the sheet i've created an automation out of it to show in my dashboard. My problem is, i could not find a way that a certain column with formula updates automatically without dragging it? Here is my formula: =IF(AND(ISTEXT([Row ID]2), ISBLANK([Logistics…
-
If and symbols
Hi I have a symbols (rggy) column "Overview Status" that looks at two columns Expiry Date and Overview Date. I would like that if expiry date is less than today to be gray, but if the overview date getting close to today to be yellow, red if it's late and green if it's OK. I would like the yellow warning to be a month…
-
Source Sheet v/s Destination Sheet
@Paul Newcome or @Andrée Starå Can one of you possibly review the discussion linked below and provide your thoughts and suggestions? I've been trying all of the recommendations received thus far and they just aren't working. https://community.smartsheet.com/discussion/comment/261225#Comment_261225 Thank you both in advance…
-
JOIN Formula from Source Sheet to Destination Sheet
Please help. I'm able to join/concantenate text from different columns in the source sheet to one column in the destination sheet. However, text from different rows in the source sheet is populating in the same cell/row in the destination sheet. Please see the screen shots and formulas below. SOURCE SHEET: DESTINATION…
-
Is possible to show a modified date entry (created by a form) in a other sheet.
I have one shet, created by a form, witha a entdy date(modified date entry), i want to show this entry at my master sheet wher i colect all other entrys. that is what i try. =IF({SKU Warenaufnahme Range 1}, [Inventory Code (SKU)]@row, {Entry daty range 1})
-
Nested If, then, CountIf formula
Hello, I am trying to create a nested If, CountIf formula, wherein the formula refers to a column and only counts status if that column is = to 1 of the 4 options. Then, ideally divide the # returned by the total to return the status over all %. For example if Column: Address is equal to: ABC Street, then Count Status…
-
Combining CountIfs statement with Date
I have a CountIfs formula that I'm having trouble getting to work when I add a date condition into it. Basically I'm trying to get a MTD output based on several countifs as well as only counting if an adjecent cell does not contain "Appointment Allowcated". The formula works perfectly when I don't have the IFERROR…
-
Turn an online survey to a printed version
Hello, say I created a form (to serve as a survey). I can push this link out, no problem. What if I wanted to make a printed version of that survey, how would I go about doing that? The use case for this is when our customers come in our office and take training. At the end of their training, we'd like to be able to hand…
