-
Use formula to create name of cross sheet range name in a VLOOKUP
Hi Folks, I have a master sheet that links to a work sheet for each row. There is a unique ID number on each row of the master sheet And each work sheet has a range named using that unique ID number. SO is there a way to look up the ID number in the row, and uee that number as part of the name of the range in the vlookup…
-
Trouble with COUNTIFS Formula
Hi, I was wondering if someone could please help me with a countifs formula that contains multiple ranges and criteria. Using the table below, I need to be able to figure out how many fresh food deliveries were done in a month. I have different locations I pick up from, and deliver to. I have a column that has what people…
-
How is the checkbox function recognised?
I'm trying to output the number of sick-days into a cell using the criteria 'email address' and checkbox ticked as i only want it to recognise the sickdays if checkbox is ticked. Don't really understand how the checkbox is recognized as I am getting a '#invalid operation' =SUMIFS([Is your absence related to a…
-
Formula to change certain Dates
Hi I am in need of some urgent help. When the date paid has been changed I want the Company Review date to change by a Full Year and the once that has change I want the due date to change by 2mths. It would be much appreciated if someone could please help me out.
-
Contact colum formula does not auto add with new row
When I use formula in a contact column and add a new row, the formula is not copied down along with all the other columns formula. Is this a bug? Thanks in advance! Eli
-
Percentage Command Issue
How do I formulate a percentage in cell "Total Percentage" using division formula based on data from "Total Score" cell? The "Total Score" cell correctly shows a result of 43. What I want to do is divide that number (43) by 50 with the end result of 86% displaying within another cell called "Total Percentage." Total Score…
-
Count number of cells that contain specific text
Hi, I am trying to work out the formula to count the number of cells that contain specific text (eg "FG"). The cells may contain more than the specific text so I want to ensure that any cell with the text is included. Some of the cells may contain text with an extension such as "FGL". If possible, I would like to exclude…
-
Adding running totals
Hi. Sorry, this may seem really simple but I am new to smartsheets. I have 2 columns. 1 - email addresses(email addresses) and another column sick days(number). I want to add all the sick days up as a running total for different peoples emails addresses but for the life of me cannot seem to get the formula right. Can…
-
JOIN Command Issue
Getting a #unparseable error with the following Join command below. I want to combine ten different comment cells and join them under another separate Comment cell. =JOIN([Comments #1]1:[Comments #2]1:[Comments #3]1:[Comments #4]1:[Comments #5]1:[Comments #6]1:[Comments #7]1:[Comments #8]1:[Comments #9]1:[Comments #10]1,…
-
Running workflow with alert & if, then formulas
When a row is added/changed, I need a workflow that kicks off an approval email to only two people. After those two people receive the alert to approve or decline (I only need one response), whichever they choose needs to fill in "approved by" and "approved date" columns in the sheet. How do I set this up correctly?