-
Additional Currencies
We are struggling with our budget tracking for projects in our APAC region, as their local invoicing currencies aren't included in Smartsheet. Some examples are: Malaysian Ringgit (MYR) Thai Baht (THB) We often convert between local currency and USD, so it can be quite confusing to not have an option for some local…
-
Getting notified of undeliverable SmartSheet automated e-mails
Hello, Is there a way to determine which Outlook receipents of an Automated alert or update via SmartSheet were not delivered or be able to create a read receipt? Thank you,
-
Removing Total Row from Smartsheet Reports
I am creating several reports that subtotal financial information by various groups (i.e. revenue, numerous expense categories, EBIT etc.). I do not want the reports to display a total row that sums all the revenue, expenses, and profit as this is misleading. Does the functionality exist to turn this off?
-
Connect Xero Reconciled Bank Account Balance
Hi, I am completely new to Smartsheets and I have an issue with regards to integrations with other software. I basically want to connect the reconciled bank balance from Xero to a 12 month cash flow I am developing in Smartsheets. I am currently unsure which trigger via Zapier to pick and was wondering if anyone knew or…
-
Merged: Request for Country-Specific Holidays and Multi-Currency Support in Resource Management
This discussion has been merged.
-
Billing Projection
All, Inquiring about breakout of 'Project Contract' to populate evenly across months based on 'Last Day of Start Month' & 'Last Billing Period.' Ex: Project Name 24006 would show $113,915 in June, July, and August to equal $341,745. Perhaps an added column in sheet is needed, that already has the even split sum. Attached…
-
Distributing Savings Across Months Based on Term Date and Fiscal Year
Hello My Super Intelligent Smartsheet Community! I have attempted to solve my problem by breaking it up into pieces and I'm stuck. I think I've been trying to solve this for too long and my creative juices are fried. I have Service Providers we have contracts with. Each contract has a Contract Start and End Date and our…
-
COUNTIFS between dates & criteria.
Greetings Smartsheet Community, I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame. So far I am successful counting the dates in the range using the following formula: =COUNTIFS({Range 1}, <=DATE(2018, 4, 31), {Range 1}, >=DATE(2018, 4, 1)) Next I'd like to add…
-
IF/OR Formula Issue with writing
Hi! I'm trying to figure out a formula for an IF/OR situation. Basically -- if the [Add-ons] column includes the tag "Prebill," I want the [Final Invoicing Amount] column to be "[Total Project Cost] - [Prebill Actual Invoiced]." If it's NOT tagged "Prebill," I want the [Final Invoicing Amount] column to be "[Total Project…
-
Local Government Uses
I am a Mayor of the city in Washington. We are looking at Smartsheet to add as a project management tool for staff. I am interested in how other local governments are using Smartsheet? Specific areas of interest are Capital Projects, Human Resources (Performance Reviews?), Permit Tracking, and Finance. Brett