-
Multiple IF's the way to go ??
Hi all, I have a column named "Site Name" this column is a drop-down single select with all our site names (approx 20 different options) for the sake of this post I will call them Rome, London, Paris, Tokyo, New York, Milan The user selects the site name via a form and this is reflected in the cell in the appropriate row.β¦
-
Index/Match
in sheet1 pulling data from sheet2 Sheet2 is 49 columns, set up a reference for column 2-49. not all cells have date in it. when i do the match, i thought it would pull up the row number, on the index - i would tell it what column to pull the data from. the date giveing me is from the next row. the results are not givingβ¦
-
Collect items in multiselect cell from one cell if item was not used by second cell
I have a cell (multi-select type) with all possible items listed. I have another cell, that is also multi-select that uses some or all items from cell one. I need to collect all items from cell one that was not used in cell 2 in cell 3. I feel that It should be somehow Join and collect minus what was used. Please seeβ¦
-
Using a Database to Autofill Cells
Hi Smartsheet Community! I am trying to create a cell autofill for email and phone in one sheet using another sheet as a database. The issue I'm running into is how do you select between identical names with different email/phone. In the database sheet, I've created a duplicate checkbox column with a formula that willβ¦
-
Nested IFblank with Networkdays formula
Hello, I have a networkdays formula I'm using to calculate that amount of days for 2 dates. Problem is if those cells do not have a date yet I get #INVALID DATA TYPE. Trying to fix this with a IFBLANK or some other formula. Can anyone help? Below is my current formula application and deemed valid are the two columns thatβ¦
-
Decimal to Binary or Working with IPs
Good morning, all. I'm trying to put together an input form to validate IP addresses we get from our customers. This would be to automatically check if, for instance, the gateway is actually in-range of the provided IP/Netmask combo, which is a common mistake we see. I don't see any built in functions that can work with IPβ¦
-
Random Select Formula?
Hello everyone! Does anyone know if it is possible to randomly select a row? My use case is a drawing for tickets. I want to be able to have people fill out a form and then use a formula to randomly select a winner. I would use "Auto Number" column to identify the person. Looks like it can be done in Excel -β¦
-
Want to track assigned tasks within date ranges and need formula help.
I'm close I think. Am tracking total tasks per team member (ASLs) and also task that are assigned within the next 5, 5-10, and 10-30 business days. The roadmap sheets this metrics sheet pulls from shows tasks owners and start and finish dates for each task. Current formula for showing all assigned tasks, regardless ofβ¦
-
How to write formula to pull current active phase or stage of the project with specific levels?
I found a formula on another post that allows me to pull the most current or active stage of the project with the least percentage done, higher than 0% and lower than 99%, but am only wanting to pull the task below the Phase and sub-phase/stage. I've created a helper column for levels and need to only index the task thatβ¦
-
I need help with a formula.
I have 2 sheets. Both sheets have dates and names. I need to compare the names, if both match then I need to compare dates, if they match I need to return a 1 to check a box. How do I go about writing this?