-
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?
-
Formulas lost when moving rows within sheets
I keep an 'active projects' sheet, and move projects to an 'inactive' sheet to keep the clutter down. The formulas do not move with the rows though, which is annoying (sometimes projects come back to the 'active' sheet when new samples come in, and I am now having to copy and pasting formulas into those cells). Any…
-
Adding Logo to Existing Sheets
I have tried to add a company logo to the existing sheet that I have created. I am unable to add it and it show up when printed to PDF. I added a workspace and then uploaded a logo and then added the sheet to the workspace thinking it would add the logo but that didnt work either. Is there a way to add a logo to existing…
-
New to Formulas
Please give me formula for: When checkbox column (complete) is checked that the column (date completed) automatically changes to today date.
-
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…
-
Build overarching report on all changes made in Smartsheet
Hello- As the admin, i'm looking for a simplistic way of viewing all changes made (not just by sheet owner or sent to) but to anyone who has editing privileges. Can i create a single repot to view all changes made in Smartsheet (let's say) over the past week. Thank you.
-
automating sending PDF
Can I automate sending a PDF voucher when someone fills in a web form on my site?
-
Formula Assistance
I’m sure I’m not the first to ask this. I could not find a post addressing my question. I am creating a sheet to track invoices through a department; receive to payment. I created a check box column titled 'January - Invoice Received' when the check box is checked i want the next column over titled 'January - Invoice…
-
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
-
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.
