-
How to show more than one month on calendar view
I am wondering if there is a way to show more than one month on calendar view. I am working creating an HR sheet and I need to be able to see the last 12 months if someone took a vacation. Also is there a way in a column to have more than 1 date so for example if someone took off both June 5th and then July 8 can we put…
-
HR Sharing a sheet
I have a company of about 10 people or so and what I would like to do is create an HR sheet that will have a variety of sensitive information. Is there a way for us to share the sheet and only have 1 person view the sheet with just there personal information? Thank You,
-
Using SUMIF to provide value of orders from this week only
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The sheet references are to single columns titled 'Completion Date' and 'Order Value'…
-
Customising subject headings in approval and other notifications
Hi. The subject headings provided by Smartsheet are too general. For example I would like to customise an annual leave approval request by having the person's name included in the Subject Heading ie Leave Request by Mytch Jeffrey or similar. I have tried using advanced settings but this is limited. Has anyone got a work…
-
Weekday Formula Error?
Hello all! I've been trying to create a time entry sheet like many others, but am running into an error with the Weekday() formula. I'm using the formula on a system column for the date/time the row was created. I have an entry for 01/22/18 4:20 PM, which returns "2" for the weekday value. Right after I have an entry…
-
Setting up Days Outstanding
Hi all! I need to fix a column in Smartsheet. The column that says "# of days outstanding" does not always automatically fill for us. How do I fix this, do I have to put a formula in each cell? Also, smartsheet newbie here, I've been working in it for about a week, so I might need extra help. Thanks in advance! Laura
-
Conditional formatting and uniquely identifying cells
Hi, I would like to only apply conditional formatting to cells that are percentages. My rules currently set any cells that are over 100% as red, and 100% or less as green. Due to the red rule formatting any cell over 1.01 a lot of my data is showing as red, wheras this really needs to be white, there is no cause to flag…
-
Calculating business (working days) in a Leave Application
I need to know the number of working days ie Monday to Friday for each Leave Application requested by workers. What is the best way to do this as most forms have the Start Date and the Return Date which includes weekends so therefore any formulas to calculate the number of days will not reflect actual work days.
-
Signatures on Forms
I was wondering if there was a function that I could you use to sign forms? I have staff of about 80 who need to sign that they have received Tools of Trade like mobiles. At the moment we are doing this with paper, which gets lost - would love to be able to set up a smart sheet and have everyone saved in the same place and…
-
Locking User Abilities
Hello, Is there a way I can lock down users to they cannot remove each other from a sheet? I would like them to be able to edit the sheet but not be able to remove another colleague. Thank you, Alex
