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 date from just the email rather than sending someone an update request?
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 to the source/reference sheet and my main sheet the VLOOKUP does not return the expected values. When I look at the…
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 which I also use to forecast, I would like to change the 'duration' of a set of tasks based on a dropdown that would return…
I would like to switch the information that is displayed in the calendar view to data that is present in another column within my sheet.
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 so I know which is which. My questions is, is there a way to just attach the attachment in the individual field that it's…
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, add filters and have it updated as soon as I add new tasks?
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 dashboard and 'card view', but I can't figure out how to do this without having to manually create the dashboard for each…
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 to change constraint type. I've exported it to MS Project and it exhibits the same behaviour until I review the Resource…
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 will show First_NameLast_Name. Thanks!
I have a report tracking all new sheets when added to the folder in my workspace. The report does not recognize this new sheet and I have to manually go into every report (many) to add it to the sheet list. Is this an error in the workspace interface or am I missing a checkbox somewhere?