-
is there a column number function for vlookup?
VLOOKUP requires a number for the column position in the table reference. But I have users who have been known to insert columns into the referenced sheet to the left of the needed column, throwing off the returned value. Is there any function I could nest inside the vlookup where I could provide the column *name* and…
-
formula for status column using symbols based on end and target dates
Hello, I would like the status column (set to red and green, ball symbols) to automatically update based on task due today vs target date. Here is what I would like: If end date is not past target date then status is green If end date is past target date then status is red Could someone help with the formula? Thank you in…
-
I need a formula to return the most common value in a column.
I need your help to create a formula to return the most common value seen in a column. I have a dynamic list of Names and I want to display the name that appears the most often in a Summary field. Mental block, sorry! I've seen very similar posts but nothing has worked. From this example, I want Joe to be displayed.
-
Formula to create a round number
Hi - I have this current formula in my summary sheet, what do I need to add to it to create a round number? =([Task Status Complete]# / [Total Tasks]#) * 100 Thanks!
-
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…
-
Inserting Unique IDs across multiple sheets
Hello, I am very new to Smartsheets and I'm really struggling with creating unique IDs across multiple sheets. I have 3 separate data sets split across different regions. I can't use regional unique IDs. I need one sequential, unique ID across the 3 datasets (i.e. a national ID). It has been advised that one way to achieve…
-
Is there a formula to count how many times todays date is entered into a sheet?
-
What formula will return the text in the field that is not blank?
The Primary Program field should contain the text from either Primary Program-A field (which is a column formula) or Primary Program-B field (which is also a column formula). I've tried nested IF statements. IF([Primary Program-A]@row, "", [Primary Program-B]@row) works but when switched, IF([Primary Program-B]@row, "",…
-
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…
-
How to Calculate Percent Complete in Sheet Summary
My sheet is used as a task checklist for projects. It currently has a 'Status' column for each Child task with 4 dropdowns (Not Started, In Process, Complete, N/A). I am trying to create a percentage in Sheet Summary that calculates the number of fields that are marked 'Complete' in the selected cells. Pulled this formula…
