-
Dashboard Chart Displaying Currency for Viewer
Hi Smartsheet community, As an Admin, I setup a dashboard with a chart showing data with $ signs. A viewer sees the same dashboard chart with US$ signs. Is there a way for the viewer to see only $? Thanks for any suggestions! Dee
-
Return a cell value based on multiple variables
I am having trouble working out a formula to put into a cell. I want the cell to change, based on the value in a cell. If the 'status' cell in my document is marked as 'complete', I want to change a cell at the end of the document to 'Complete'. If the status cell is marked with anything else other than 'Complete', I want…
-
Prioritize Order of Record Fulfillment
I have a list of records in a worksheet, and would like for each of them to be prioritized 1 through ### (depending upon how many are in the list). Each record needs to have a unique priority, because the order in which the record will be acted upon by an Owner will be determined by where it is ranked in the…
-
If And Formula Help
Greetings! I am new to the forum so I apologize if my question is redundant! I am trying to combine two "If" statements into a single formula. I need smartsheet to look at two columns (Due Date) and (Project Completed -- checkbox) and determine if a project is late. I can get each half of the formula to work individually,…
-
Calculating Totals
Dear all I deal with importing goods from all over the world, and payment usually happens in multiple currencies. In smartsheet, I have a column for currency (USD/Euro etc) and the next column I have the amount. What I am looking for is a payable total in each currency, E.G. For Payable euro, the formula will look at all…
-
Linking Cells and then Sorting Source Sheet
I am working on creating a master list of events, that pulls data from 2 source sheets. I worked out the linking, but when the source sheets are re-sorted it messes up my links on the destination "master list". Is there a way around this? The source sheets are not able to remain static pages and will be used and updated…
-
Clean up Sumif Formula
I have this formula to give me the sumif for multiple criteria I was just wondering if there is a simpler formula =SUMIF(@{Healtcare Range 3}, @cell = "Memberships", {Healtcare Range 2}) + SUMIF(@{Healtcare Range 3}, @cell = "Sponsorships", {Healtcare Range 2}) + SUMIF(@{Healtcare Range 3}, @cell = "Client Seminars /…
-
Countif Query
Hi, I currently have the following formula which is used for counting how many jobs we intend to complete on a day: =COUNTIF({Realistic Completion Date 4}, {Realistic Completion Date 4} = TODAY()) This works fine, although there is a scenario where we often add things to the job, which is identified by a letter A in the…
-
Is there a way to track the number of work days in each "Status"?
I would like to track the number of work days an item is in each status. For example, an item was in Feasibility Assessment status for 3 days and UAT status for 8 days. Is there a way to do this in Smartsheet without using a third party tool?
-
Converting UTC timestamp to Hawaii Standard Time timestamp
I've been importing data from Toggl (toggl.com) using Zapier (zapier.com) to SmartSheet. The date/times are recorded in Toggl in UTC, and I'm trying to convert this to HST (i.e. -10 hrs). My settings are for HST. The UTC format: 2019-03-15T02:43:21+00:00 I've tried several suggestions in other posts/solutions for…
