-
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
-
Refund.
I need someone to someone to help me get a refund. I didn't get a notification that my account would be debited and I no longer need smartsheets. Why is there no notification sent out to warn users that their subscription will be renewed?
-
Do you know why Smartsheet 'forgets' my existing subscription?
I subscribed and paid for a yearly Pro subscription this October. Everything worked as usual for 3 weeks, then Smartsheet seemed to forget my account and email address completely. When I tried to sign in after 2 weeks of not using it, it requested me to sign up for the trial again. Nothing else worked with the same email…
-
Subtract Invoice amount from Total based on Status, in Parent-Child relationship
Hi all, I am new to create sheets, but I am trying to create a solution to track forecasted invoices that need to be sent out. I want to put each invoice total separately and when the status is marked as "Complete" I would like to have it subtracted from the Contract Amount to show the Contract Balance. I set it up so the…
-
Merged: Dropdown options for approval workflows
This discussion has been merged.
-
how to set up info sheet to feed into Resource Management
I have entered this data and am using it as a way to track allocations across different projects. The different projects are indicated by the different WRT #s in column 1. I need to then summarize the last 2 columns by WRT #, which I've done here in a report. I am wanting to add some type of flag or conditional formatting…
-
How to calculate time in smartsheet
Hi, How to calculate difference in time in smartsheet for example Start Time = 12:23:20 and End Time = 20:23:20 I want the difference between this two time in third column = 8:00:00