-
VLOOKUP reference file not being captured through end of sheet
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…
-
Change task Duration based on a condition in another cell
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…
-
Is there a way to re-designate the primary column after a Smartsheet has been developed and populate
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.
-
Is there a way to add attachments to individual fields?
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…
-
Can you create a filtered version of a smartsheet without having to link each link one by one?
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?
-
Gridview to Dashboard
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…
-
Task not scheduling properly
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…
-
Adding a space between 2 vlookup functions
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!
-
Report not updating when adding new sheet
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?
-
Scroll via trackpad not working after update
Anyone else have the issue where you try to scroll through a sheet with a trackpad but the sheet doesn't scroll? This has been going on for awhile and I notice it on all my devices (Surfaces) and on different browsers (specifically Edge) in Windows 10. Mouse wheel works. Happened after an update I think...