-
Quickly edit linked cells
Enhancement Request: The ability to edit cells linked from another sheet - either directly or by double clicking and being able to edit the original sheet in a pop-up. I have a master sheet with all of our project level data on it and engineers have individual sheets for their projects which allows them to add any kind of…
-
Cell linking within a sheet
Hi there, I understand that you can link cells in Smartsheet between sheets, but I have been unable to link cells within a sheet - does anyone know if this is possible in any way? Thanks, Paul
-
Setting Up Rules
Hi I would like to know how to set up a rule where if a certain selection is made from a drop down in a cell that it automatically prompts you to complete a related cell. For example: If a member of my team update the Recruitment Status for a vacant role to show 'Offer Made' I would like a prompt set up to automatically…
-
Linking date columns
Hi, I am linking date columns from a master sheet to another sheet. When linked it seems to change the format of the date. For example if the date in the original sheet is 12/08/19 (12th August 2019) in the linked sheet it is displaying as 08/12/19 (8th December 2019). The original cell doesn't have any dependancies.
-
Automated alerts for changes to cells linked between sheets?
Hi, We have sheets that have linked cells between them. I want to set up automated alerts if someone changes any information on that row, but would settle for changing specifically the dates (which are also linked). Is there a way to do this? Thanks!
-
Linking upcoming dates from sub sheet to the master sheet
My company has a master sheet connected to all the different project sheets. Is it possible to have the next due dates listed in the project sheets automated to update on the master sheet? Currently, we're just doing this manually and it is a pain for us to constantly look at the sheets.
-
Auto populate data in other columns by selecting dropdown value in primary column
I'd like to select an item from the dropdown menu in my primary column, and have the two following columns fill with predetermined information. Example: We have 100 items. When I select one from the dropdown menu in column 1, the following two columns automatically fill in the prices associated with that item. Can this be…
-
Formula Help
Greetings- I'm struggling with the cross-sheet referencing and need some help with a formula. I want to create a new sheet summarizing the values on a corresponding dropdown menu for the name and # of products we sell. I'd like the total number sold for each dropdown choice displayed on the new sheet. In the screenshot,…
-
Hyperlink to a specific row in another sheet?
Is there a way to hyperlink from one sheet to a specific row in another sheet? I want to be able to click on the link to jump from one sheet row to a specific row in another sheet. Thanks, Stan
-
Show date as day of the week
How can I use this forumla =TEXT(A3, "ddd") ?? This formula calculates the day of the week for the date and returns the abbreviated name of the day of the week (Thu). Every time I try to use this formula, it says "not recognized".