-
REMOVING ALL HIERARCHY FROM SHEET
I'm using a sheet (Grid view) that I initially needed Parent and child rows on, but we have decided we would like a simpler format. I don't want to delete my sheet and start over because I need all the current data as I am still using it. BUT I want to go back thru the sheet and re-format it without the parent/child…
-
Counting unique values over different date ranges
Pretty new to SS, I've only been working with it for less than 2 weeks. I have a sheet with pto requests, I need to count the number of team members that have submitted a quest in a quarter or a year or whatever date range I need. Team members can and have submitted more than 1 request per quarter/year ect. So basically I…
-
Enhancement Request: Filters to include and / or functionality
I would like to request the ability to customize filters by adding specific conditions to each row. The filters currently have an option to show rows that match all conditions or an option to show rows that match at least one condition. Because we share our SmartSheets with multiple teams, I would like the ability to add…
-
Drop down list column \ multiple choice
Dear support! Could you please help me to understand if it's possible to use multiple choice in a column with drop down list? I mean that maybe there is a way to create something like that?
-
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