-
Calculating how long a query has been worked on and how long it remains at particular statues for
Relating to this previous community query, I've got 2x similar queries.. I've posted it in that conversation but wasn't sure if it bumped it up the queue, so thought I'd post a new thread just in case it wasn't. I've used the formula @Paul Newcome provided in his post to tell me how long since the creation date the…
-
Make Cell Usage and Formula Usage Counts Visible
When troubleshooting issues with data limitations, I often need to check with a Smartsheet specialist about the number of cells used on a sheet. They will be able to refresh a view and find this to compare to my calculations of rows X columns and/or the little gray tooltips displaying in the bottom-right of a sheet when…
-
How to recreate a payment month Excel formula in Smartsheet
Hoping you might be able to help me with migrating a formula from Excel into Smartsheet. I'm in the process of recreating a payment tracker solution for some colleagues of mine, but I'm struggling to replicate one of the formulas. The formula is as follows: =IF(DAY(C4)<=3,TEXT(C4,"yy-mm(mmm)"),TEXT(C4+30,"yy-mm(mmm)")) The…
-
How to check if cell contains one thing or another?
Hi all, I'm making a sheet that references another sheet to get data for a detailed graph. I'm trying to count the total number of small, medium, and large projects. The formula I have that works for individual campuses is as follows: =COUNTIFS({Size}, CONTAINS("Small", @cell), {Campus}, CONTAINS("Example", @cell), {In…
-
Dashboard Formatting, Displaying Data, and Cell Linking
I am stumped by formatting in the Dashboard. The first pic is how I would like to display the development schedule on the dashboard. It is very clean in comparison to the only way I have found in SS (2nd pic). Any suggestions on how I can get the better display on Dashboard? I would love for the data to be in SS so the dev…
-
Unlicensed user - admin
Hi all, According to this link: Sharing permissions on sheets, reports, or workspaces | Smartsheet Learning Center it seems like an unlicensed user can never edit cells in locked rows or cannot remove locked rows. However, when we try this (unlicensed user with admin permission), we are able to edit/remove locked rows.…
-
Is there a better way???
=IF($[Year Select]$2 = "2023", [2023]@row, "" + IF($[Year Select]$2 = "2022", [2022]@row, "")) I am having an issue where I can select 2023 just fine, but when I select 2022 all of my reference dates change to a "Text date" and the formula in the data 1 & 2 columns do not recognize it. Is there an easy way to fix this? Or,…
-
Looking to reference a sheet name on a different sheet
I have a sheet that uses a nested formula to scan 3 different sheets to pull in specific data related to a Sales Order number. Is there any way to craft a formula that will produce the name of the sheet where the information was pulled from? -Using a report will not work because the function of the file is to pull in…
-
Find unique value in Children
I am looking to determine if a value in a cell of a child is unique among the other children. Order Number | Items | Cost | Overall Unique | Order Unique | Total + 100 | | | 101 | Oranges | $1.00 | Yes | Yes | $1.00 102 | Apples | $2.00 | Yes | Yes | $2.00 103 | Bananas | $3.00 | Yes | Yes | $3.00 + 200 | | 204 | Pears |…
-
How to fix #UNPARSEABLE for my nested IF formula
Here is my nested IF formula and I don't understand where the issue lies. I've created a new column called [Initiative Expense] for my formula. My [Initiative Type] column has multiple values for types of expenses and credits, but if the value is one of five expenses (listed in parenthesis in the formula), then I want the…
