-
how to pick a specific item from a multi item dropdown cell
I have a (Dropdown, Multi select) column, cells with up to 10 items. I figured out how to count them (countm), but I cannot find a function, or figure out a way to pick inidividual items. EG, cell contains item L001 G02 L003 0L005, in no order or specific length. So countm=4. So how do I extract item1 L001? or item 4 -…
-
Calculations with dates
I need help figuring out date calculations. I've tried many different things and nothing works so far. I have a list of projects, each project has a list of tasks with start and due dates. I need to calculate the difference between the start date of one task and end date of another task (always the same 2 tasks). In my…
-
How to capture a value from multi-select column
Which formula works better to find out if a value exists in a multi select dropdown column? I have responses collected from a survey and one of the column was multi-select dropdown list type column. I'm trying to separate out the selection values and adding them in a separate sheet (so using cross sheet reference). Have…
-
Estimating Available Award Dollars when awards have asynchronous start dates.
Background: We're a research organization that receives a variety of federal, state, and private awards to conduct research. Awards are received throughout the year with a variety of project periods ranging from 1-5 years. Objective: Derive an estimate of how much "cash" we have in the bank at any one time. Averaging the…
-
VLOOKUP - want empty lookup result to allow free form typing
Hello, I'm using this formula: =VLOOKUP([Location Search]1, {Locations Range 1}, 2, false) where [Location Search] refers to a "LOCATION SEARCH" column in the sheet collecting the data and {Locations Range 1} refers to my look-up table below. It returns the "LOCATION RESULT" column below and I need it to be exact...thus…
-
Join Function Not Working As Expected
When I join across cells it is taking the last option from the Core Column and the first option in the Calyx Column and combining the text. Any suggestions will be helpful. The formula I am using is =JOIN(Core1:Calyx1, " ")
-
Changes since last week
Hello, Is there a way to show changes since last week to a 'date' column? I don't want to highlight the change, I want to be able to see if the date moved since last week and then calculate the number of days it moved (eg: +10) I don't want to right click and view cell history either. I want to show a simple report/project…
-
Project Dates and Coming in on time
Hi, I'm trying to set up a project template using a Gantt chart so that when the Certificate of Occupancy date is plugged in, it will automatically populate the goal dates for all the tasks prior, based on how long those tasks take, in order to be ready for the CO date. For example, if I know that a permit takes 2 weeks to…
-
Counting Hearts
We are using a sheet to rate name suggestions. Each employee has their own column and they rate each name suggestion using the heart scale. Does anyone know how to count/sum the total numbers of hearts in a row? Example: I rate a name ❤️❤️❤️❤️❤️, someone else rates it ❤️❤️ - That name suggestion would have a…
-
Can a Form have multiple entries and have them display as multiple lines on the smartsheet?
I have a form I'm using as a maintenance work order log. I have them fill out a form, which in turn fills out the order log. Is there a way to have them enter multiple parts and descriptions and have them populate on multiple lines in the smartsheet order log? If they do have to enter a form entry for every part they want…
