-
IF function/moving row's across sheets
Hi, I have multiple project sheets, whereby each row represents information about a project. I would like to know if there is a feature whereby if i was to enter into a field that this project was complete, that the entire row could be moved to a new sheet for completed projects. E.g. if i were to enter a "tick" or the…
-
Help Needed! - IF rule
Hi,, I am trying to total a column based on whether a value has been entered (but to ignore the actual value), giving a total of the cells with values in. Something along the lines of IF value greater than 0, to count that as 1.. Help would be greatly appreciated if anybody knows the formula?? Kindest Regards, Ben
-
Repeating rows based on one cell value
I am try to go from a proposal to a detail sheet for our business. We make doors and you can have from 1 to about 100 or more of one type of door. On the proposal it is only shown as one line with a quantity cell. Now what I want to do it link that to a detail sheet, the sheet that will go to production, and list those…
-
How do I add a picture on Sights
How can I add a picture to my Sights. Your sample below appears to allow this function, but I cannot figure it out.
-
How to include parent rows in reports?
Is this possible? Saw a workaround (https://www.smartsheet.com/blog/smartsheet-tips-displaying-parent-rows-reports) but is there an easier way? I see an example it in the Sights Gallery - Sales Pipeline as well
-
Workdays excluded by person option
We have a need to add workdays excluded by persion option to our project sheet to accurately account for the duration. I can see you can exclude holidays but I want to exclude days off extc. Is there a way to do that?
-
Feature Request: Picture for contacts
It would be really nice to be able to create profiles for the users that incorporate their photo as well as their text data. Preferably with the ability to auto populate a user photo column if the user is selected from a dropdown box.
-
Can hidden field on web form designate parent-child row status automatically?
Our Smartsheet has a client name column along with a designator column that indicates what type of work we are doing (M, S, or C). We have a web form set up for each (M, S, or C) using the hidden field so that when an "M" form is submitted, conditional formatting tells it to bold and back fill the row. Is it possible to…
-
Can I have multiple attachment fields in a web form?
I have a new requirement to have more than attachment field in a web form. Example: the form asks for specific budget information in one section requiring upload(s), and then in another section we would like to add an area to add receipt information. It would be OK if they are stored together in the Smartsheet when…
-
create row synchronously between sheets
Hi, Sheet A has the original data, which contains customer name, address, phone number, and other personal informations. And sheet B's data is linked from sheet A, only link customer name, address, phone number columns. I'd like to share only sheet B with other staff cause sheet A has too many personal informations. Could…