-
If a date is between 1.01.2020 and 31.12.2020, get the cell checked
Hi everyone, I have a list of documents that have been uploaded throughout different years. I would like to count how many of them have been uploaded in 2020. For this reason, I would like to create a column where the cell will be checked if the column "Date Uploading" is in 2020 and then report it on the Summary Sheet. Is…
-
Sheet Template : When copying a template, my formula's don't migrate.
I'm trying to copy a template to use. I have formulas already on the template, however when i put the new numbers in, it doesn't use the formula to add/subtract them. I have to litterly go through and on every sheet I create from either a template or otherwise, I always have to figure out the formulas again. Is there a way…
-
Excluding item on a dropdown when returning sum in smartsheet
Hello beautiful people, On a second sheet, I need to pull in data from a first sheet. Some columns on the first sheet contains the following: - Service Type - Commodity Category - Invoice Amount The Commodity Category column is a drop down of items, which includes "LLIN". I want to get the sum of the Invoice Amount of…
-
how to force a formula to work on each new field created automatically
Hi there, i using a form that create new rows in sheet, i'm using a formula that lives only in the sheet how can i force the formula to automatically work on every new row that's created without the need to drag the field manually. Thanks Tomas @Netanel yosef
-
"#NO MATCH" Error for Vlookup with duplicate contacts
I have a problem where I have a very simple "VLOOKUP" formula meant to return a contact from another sheet. Of the 9 contacts in the field, only 3 are returning an error that stats "#NO MATCH". All of the other contacts are returning and displaying correctly. The only connection I can find is that all three of the contacts…
-
Work Week Formula
Hello, This may have already been asked however I am not seeing it in the threads, I am looking for a version of this formula =(WEEKNUMBER([Date Entered]@row)-5) to function properly so that it shows the work week (screenshot) : Previously it worked without any issues and showed the 'Work Week', now it is giving me a -4:…
-
IF Column A = True then Status = Archived, else status can be any value (New, In Review, etc)
I've got the formula working for Archived, below. However I want it to work that if it's not selected a user can manually select any status in the drop down (New, In Review, Review Completed). =IF([Informational Only]@row = "True", "Archived") If I keep it this way, when I select a different status than Archived it wipes…
-
Prior Year SUMIFS with multiple dropdown selections
Hi - I'm trying to figure out how to make this formula work. I've tried several different ways of listing the Status options and it keeps saying #UNPARSABLE. I'm trying to get the dollar amount of rows that meet criteria in three columns: Source, Status, and Date Received. Source and Status are both multiple dropdown…
-
Text Comparison across two sheets to link a multi-select field.
Hi everyone, I am having some difficulty with the following: I am trying to link/copy/bring-across a multi-select field from one sheet to another based on a Text Field Comparison. See example below: Lets assume that Primary Column and Result Column are on Sheet 1 and Column 3 and Column 4 are on Sheet 2. User populates…
-
Notification delay
I have a series of workflows set up for a form/sheet I am using. The process goes like this: 1. Someone submits form 2. Triggers approval email to be sent 3. If approved, this triggers an email to the requestor that their request has been approved. 4. This also triggers a different email notification to another email…
