-
I have a parent row that needs to populate with appropriate 'Status' based on it's children
I have many parent rows with many children, in some cased grandchildren. Each child (or grandchild) has a status. Status choices are; Not Applicable Not Started In Progress Complete I have to account for the following possibilities; I have been able to write a formula for the first 4; I am having great difficulty writing…
-
I am trying to create small chart for dashboard
I have a master sheet that has 100 projects all different end dates. Trying to find a formula or method create small chart like a sample Jan 2022 - 4 Feb 2022 - 3 Mar 2022 - 4 Etc...
-
Mass ticking a column, for users who have Dynamic View
Dears, Background : I have a question regarding a Smartsheet tool that I am operating. Essentially, we are using Smartsheet to create, collect and align on data, which then creates reports for the higher level stakeholders. However, since the data is highly confidential, we have to manage access and authority very closely.…
-
Newline for Mapping
Hello! I have been creating a sheet that pulls data from a hotel database and then maps it into a pdf. I have been trying to get the sheet to pull as many suitable (in this case, from the same town) hotels as possible. The only way that I have been able to do this is by using =JOIN(COLLECT({Hotel Database Name Range},…
-
Average based on 1 criteria
I'm sure this is user error but I'm trying to average out compensation based on the job code then I'd like to create either a data mesh or vlookup to fill in the blank compensation with these averages. I've tried having a seperate sheet that has the job codes and then I'm trying to use the averageif formula. However I keep…
-
How do I enter criteria to return specific results, but not using filters or dynamic view?
I'm curious if anyone has an in-sheet solution for this. I have a lot of data related to store information (store #, address, software versions, regional manager name, etc.). It encompasses all information about a store location and there are over 1800. Is there a way to build a sheet so you can type in the store # and…
-
Schedule Variance
How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and track schedule variance.
-
JOIN DISTINCT CHAR(10) List on Sperate Rows
Hi, I have the following formula which collects a list of a dropdown column, and removes duplicate values, is there any way that the returned list of values should be on separate rows of this column formula? =JOIN(DISTINCT(Dropdwn:Dropdown), CHAR(10)) Thank you,
-
Help combining: IF INDEX MATCH
Hi, Please help me with my formula, I'm trying to GET a Contact Column, based on matching criteria, (The columns referenced are from a separate sheet.) I tried using: =IF({Sheet 1 Range Status Column}, "Approved", INDEX({Sheet 1 Range Contact Column}, MATCH(HAS(@cell, Reason@row), {Sheet 1 Range Reason Column}, 0))) It's…
-
Formula returning 0% instead of correct value in the sheet...
Not sure why my formula (using Index and Match) is returing 0% as a result of matching to another sheet? The correct data in the cell is = 55%. All other columns with same formula working correctly but one dept is showing an error o= 0%. Here is the formula =INDEX({Feb Score Column - BEAUTY}, MATCH(UII@row, {UII Store -…
