Currently, when you double-click on an image that is linked from an inserted image on another sheet, SS opens the "Link" dialog. Wouldn't it be better if the larger image preview opened, like it would on the source sheet?
I'm linking cells between two sheets A and B. When my project manager changes a row's start or end date in their sheet A that links to my sheet B, can I have an alert triggered by this change to notify me via email? Is there a better way to achieve this type of mechanization? Another way said, once my PM is done with a…
How can I generate the sub dates on a Gantt sheet using the duration? I would like to be able to copy my project and the subdates automatically generate from the head date? This could be generated by the duration. For example If the Head start date is 1/3/2016 I would like the sub dates to auto generate from the duration…
I need to populate the information in the primary column from a dropdown menu but cannot because of the type of column. If I place a column next to it with the dropdown information, can I use an If-Then formula such as =IF(ISTEXT([Client name drop down list]1), "Text", "Not Text") where I change the "Text" to equal…
I am not sure if this can be done in smart sheet. I need to track assets by location. There with be up to 50 assets by location and several thousand locations. I would also like t have the ability to add the bulk of the items from a location kit as all have common items with a few variables as to how many of each. All…
I understand that SS will not update the same row from two separate web forms. Does anyone have a workaround for this. I want to use a web form to collect safety issues from employees. i then want to send the information to the employee's supervisors to have them take some actions and report what they have done. I know I…
Hi! I am trying to use a Web Form to populate a "Master List" full of 30 columns of information. I would like the info located on that "Master List" to trickle down into 3 different "Sub Sheets" that present only selected info from the "Master List". However I am having trouble getting blank cells to understand that once…
When I print the sheet to pdf the indented rows are collapsed on the pdf but they are not on the screen view. This is not happening with other sheets. This paritcualr sheet has: - many links to other sheets - i am not an editor Is there something else I need to do for the indented rows to display?
我would like to sum up the hours of a job according to what job number it has. This is going to be used as a Time Sheet. Therefore, mass amounts of entries are going to be sent to this report. I would like it to automatically sort the information and then sum up the hours of multiple cells that have the same job number in…
Hello, is there a way to merge the text of 2 different cells into 1 please? I have tried several versions of this but I get different error messages. =(([cell]1) &” “&([cell]2) Thankyou.
