Each time I add one more row to one sheet (Sheet A), I want to trigger the addition of 7 rows to another sheet (Sheet B) . The data in the 7 rows will be driven off of 2 sheets (Sheet A and Sheet C). …
I was wondering if there is a way to have someone edit a field when you just send a row to someone. What I mean by this is would be the person receiving the email able to check completed or update a d…
I am having an issue with VLOOKUP. I will attempt to explain. When I set up the parameters to "reference another sheet" I capture all of the row/columns through the end of the sheet. As I add new rows…
Hello Everyone. The projects I handle are the same each time in terms of the tasks to carry out. but they can differ in duration based on the 'size' of the work... I am using a standard sheet template…
I am working my way through a spreadsheet horizontally and adding the relative attachments to the attachments section to the left of the spreadsheet and labeling them with the same name as the column …
I'm trying to create a live copy of sheet1 so I can filter and share with execs. I know I can link sheets but I don't want to do that every time a new tark is added. Is there a way to create a copy, a…
I am collecting data on hundreds of IDs that are designated by the primary column in grid view. Data is added as additional columns. I'd like to be able to condense the data for each ID, e.g. using a …
I have a plan in a smartsheet which isn't scheduling as expected. several task that have no predecessor seem to be staying put. I'd expect them to move to the project start date. I can find no option …
Hi All, How can you add a space between 2 vlookup functions? Here's the formula: =VLOOKUP(Alias247, {Pilot Data Base Range 4}, 3, false) + VLOOKUP(Alias247, {Pilot Data Base Range 4}, 2, false) This w…
