-
SUMIF
Hi, I'd like a formula to calculate the below SUM the leave days Request(Column Number of Days) against the employee(Name Column) if Approved(Manager Column) and Approved(EXCO Column). If either one of them are not approved then don't SUM the leave days. This is what i have so far but cant seem to get it to work.…
-
Enhancement Request: Ability to use Rich Text or HTML format options for Comments
I would like to request the ability to use different format options in the comments window. We are currently able to add plain text comments but it would be nice at times to use a different format like Rich Text or HTML.
-
Automatic Archiving
I'm creating a weekly schedule in a sheet and I would like to automatically archive that sheet after the week is finished, and save it as the name of that week. Does anyone know how this would be done? Thank you!
-
Use Countif to count the number of tasks assigned to a worker?
Hi, I'm sure there is a quite dimple solution to the this, but I am having trouble. I want to count the number of rows assigned to each contact, and I used the formula below: =COUNTIF(Assigned Work:Assigned Worker, "contactname") The formula returns the error #UNPARSEBALE How can I fix this?
-
Recurrent Reminder for anniversaries and Birthdays - old dates
Hi there, I set up a spreadsheet with all our employees' details. Now I need to set up recurrent reminders for Date of Births and Anniversaries, but obviously, being old dates they are not considered. Is there any way where this can be done? Thanks
-
Adding a grid to a Form
Hello, I'm wondering if there's a way to add a grid to a Form to collect data when multiple names, emails and job titles are submitted. Currently we ask people to submit a PDF form to us that has an embedded table where they list the staff who have taken a training. The table headings are: Name, Email, Job Title. Sometimes…
-
Sharing Reports
Is there any way to share information on a report without giving employees access to the sheet it's connected to. This main sheet uses forms and may carry confidential information and I don't want them to view the full details of the sheet, just a few important key items on a report. Is this possible? This is in regards to…
-
Gantt view on a dashboard report
I'm trying to include a report with it's corresponding Gantt chart on a dashboard. The report is set to open on today's date. However, in the dashboard the Gantt chart starts in June and I can't even scroll back to today's date (see attached snapshot). Can anybody help? Thank you.
-
SUMIFS using Fiscal Year Date Range
I'm trying to sum monetary amounts for a certain customer while referencing the data from a separate sheet. However, I only want to sum those amounts that fall within the FY20 (fiscal year) dates of 4/1/19 to 3/31/19. Here's the start of my formula that sums all dates, but what conditional formula do I need to add that…
-
How to convert dates to Long Form Date format?
I understand that date formatting is normally set in "Personal Settings" but in order for the SmartSheet Merge to work for a problem I'm trying to solve, I need to convert the date to the long form (February 11th, 2016 instead of 11/02/16. Is there a script or IF statement that I could use to make the change? Thanks, SRC
