Hello, I have a sheet for users to enter requests for our quality department. They chose a type of task they need, i have a VLookup assigning how many hours to assign to that row based on the task. Th…
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 …
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...
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 hig…
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) h…
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'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 inform…
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 templa…
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 f…
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}…
