-
VLOOKUP WITH MULTIPLE SHEETS
Hi! I´m trying to use VLOOKUP with IFERROR formula to find an information in more than one sheet, but it´s not working... The formula I´ve been trying: =IFERROR(VLOOKUP([SV / OS]@row;{Base Transações Intervalo 1};6;0),(VLOOKUP([SV / OS]@row;{Base Transações 02 Intervalo 1};6;0))) It always return #UNPARSEABLE I couldn´t…
-
How to use IF function to compare two dates and tick checkbox
I would like to use a IF function that test that when the date that the user input in a form in the Form sheet is the same is the date listed in the "Availability" sheet, it must tick the checkbox. I am currently using this formula but get a "INVALID OPERATION" error. Both columns are 'Date' type. The objective is to use…
-
How can I access the name of a sheet in a formula?
we have the convention where particular series of sheets start with "YY_XXX9999_etc" where the YY is a overall Project code and the XXX9999 is a code for the location where tasks will be done. I want to extract the code from the sheet name and use it to populate the sheet with additional information from a master list of…
-
Calculating how many days passed (between 2 dates)
Hi All, I am wondering if you can help. I have a very basic formula in place to calculate how many days passed from date 1 to date 2. I used NETDAYS formula. Since we use it to calculate the time from when the issue was raised until it was resolved - the end date is not always there straightaway which of course brings back…
-
Adding 30%
Need help adding 30% to the Buildout Cost when "Union Labor" is selected. The formula I'm using is just giving me 30% of the value, not adding 30% to the value: =[Square Feet]@row * (IF([Cost per Sqft]@row = "Aesthetics Only $125/SF", 125, IF([Cost per Sqft]@row = "Aesthetics w/ Plumbing $150/SF", 150, IF([Cost per…
-
Division help...
I would like to create a formula that divides the square feet by a certain number based on the selection in the Projected Buildout Cost column. This is what I have so far and it's not working: =[Square Feet]@row/(IF([Projected Buildout Cost]@row = "Aesthetics Only $125/SF", 125, IF(Projected Buildout Cost = "Aesthetics w/…
-
Need cell to populate with fixed percentage amount of previous cell
Hi all, I am having trouble doing something so simple, I think I'm making it harder for myself. I have two columns, "Hard Job Cost" and "Commission", as I get a percent of the job as commission. So, if the "Hard Job Cost" is $30,000, my commission is 1.5%. I can't seem to figure out how the "Commission" column shows the…
-
Pulling Cells Information by Date into Sheet Summary
Hi All, I'm pretty new at Smartsheet and I'm getting the hang of it, but I'm stuck on this one. What formula can I use to pull in any Location name that has a "Live Date" within 2 weeks of today's date? Here's my table: Any help would be greatly appreciated!
-
Formula for "Allow Multiple Contacts per Cell"
I have been tasked with creating a dashboard with some metrics on it. Below is an example of what I am looking to have created. On one of my smartsheet columns is an "Assigned to" section. There are 3 people in that list. Bob, Jan, and Jill. Bob has 1 row assigned to him. Jan has 1 row assigned to her. Jill has 1 row…
-
Date Format not translating to plain text
I have a Date column which I have formatted as short form Day and Date (example: Mon 18-Sep-2023), which I am trying to convert to plain text. I know adding +"" to the formula of the other column will convert the Date column into plain text, but it returns as 09/18/23, not "Mon 18-Sep-2023". Is there any work around for…