Jessb9187’s Profile

points
133
Company
ABC Financial
Area of expertise
Financial Management
I'm a Smartsheet newbie! I am from Illinois and I work in IT.

I am trying to calculate a total number of accounts that are based upon a few different criteria specifically within a date range. So for example, I need to calculate the total revenue for a list of clients that had canceled within the year 2018. I have a formula that I used to calculate this total

Hello again,

I am using a pretty basic formula which I've used countless times, even yesterday, and now I'm getting an #unparseable error.

I need to add the number of onsite days (range) if the visit type (criterion) is listed as a conversion. My formula looks like this:

=SUMIF({KPI: Visit Types

Good afternoon,

I am trying to get a cell to auto populate with a specific word if another cell has a specific range of numbers in it. I keep getting an #unparseable but I found this formula in the community and it worked for someone else trying to perform the same thing.

I have 5 tiers of numbers

Hello,

I am trying to combine these two functions to find an average number but only if it meets a specific criteria. For example, I have cases worked that can be canceled for 3 reasons. If the case is canceled because of a "No contact" with the client, I need to know the average number of days the

Good afternoon everyone,

I am having a heck of a time trying to figure out why my formula keeps returning as #unparseable.

If a Category says Expedite, the cell needs to show \$25.00, if not, it needs to show \$0.00. My formula is =IF(Category1 "Expedite", \$25.00, \$0.00).

I've tried removing the

Hello,

I am wondering if it's possible to toggle whether or not people can view a workspace I've created.

In this particular instance, there is a large set of different sheets that are updated monthly for SLAs and are then sent to a corporate team for review.

We want them to be able to see the

Hello everyone,

I am trying to calculate an amount based upon the sum of two numbers. If you look at my screenshot, the highlighted Hotel and Transportation budget amounts are based upon the # of Days Onsite plus # of Travel Days. I need the system to be able to add those two numbers together and

Hello!

Smartsheet newbie here:)

I was trying to use a simple SUMIF formula to calculate the total number of days for a specific field. For example: I want to add all the days or duration for all projects that were labeled as "Conversion" together to calculate the total number of days spent on all

I'm trying to create a condition based upon user submitted data for over budget flight requests. If the flight type is a One-Way, then whatever the pre-tax amount should be subtracted by the budget amount to give me the over budget amount. This formula is =SUMIFS([Flight Cost (Pre-Tax)]1 - 350,

Hey everyone!

I just started using Smartsheet and so far am blown away by everything! At the moment, I'm trying to use the SUMIF formula to calculate a total cost but only if the number being used is below 0. For example, If Column A is a negative number, I need the formula to subtract it from