Hi, I'm in need of a little help. I am trying to create a spreadsheet that allows me to calculate the reimbursement amount. For instance, if the employee returns a receipt over the allowance amount then the total would be the allowance amount. If it's less than the allowance amount then it equals the receipt amount. It…
Hello, Has anyone successfully used dates to pull totals? I'm trying to do the following: Columns: Start Date | End Date | Status 1/2/18 1/10/18 Completed 1/5/18 1/7/18 Completed 1/5/18 Open 2/8/18 2/15/18 Completed 2/16/18 2/20/18 Cancelled Output: Total 'Completed' for January 2018 = I'm wanting to use the dates and…
Hi, I've tried to find a solution for this, but maybe it's a too generic wording problem. We have a Master Project list, that has the start and end date of every project we have, as well as it's budget and projected profits. I want to have an overview of how much money is allocated to each month and for that I need to…
I played around with the publishing calendar functionality using ICal and syncing it to my Outlook account. I eventually decided not to use this function and turned it off in SmartSheet. Several times a day I am getting an error message in Outlook related to publishing the calendar. See the attached screenshot. Any ideas…
Hello, I've set my CF rule to look like the screen shot I have attached. I've been over it for what seems like 100x but it's just not working. Can someone please help?
In the spirit of sharing, I thought I'd let you all in on the Arial Unicode Right-To-Left Mark character that can be used in forms to add blank row between Help Text and the form value. As per the image below: * begin by selecting and copying the U+200F character from the Arial set in the Windows Character Map application.…
Notice in the attached picture that I have a chart that shows how much reimbursement a specific client received last year and as of the current date the client has received almost half of that. The issue is that the FY1718 (Red) column appears too small for the actual result. Visually, shouldn't it be about half the height…
Is there a way to clean up the drop down list on "is one of" filters? They still contain items that have been totally deleted from the column being filtered. This is very confusing to users. Thanks
Is there any way to automize a process to transfer tasks from email account (on Mac) to Smart Sheet ?
I want to create a form that I can e mail the link to my employees on site weekly to collect hours. Ideally include Employee Name Start Date of week Day Site from a drop down list Hours at site Options two sites per day. Note at bottom to advise on holiday , illness Thanks in advance Grant