-
Want Dashboard to Update with Data Live Based on Report
Hi - I want a dashboard I have created to update with data live based on the report I have input into the dashboard. Is this possible, by which I mean can a sheet update live based on a report so the metric widget reflects those numbers? If not, what are other solutions, and if a formula is needed can you give me the…
-
CountIF for whole column Not just a range of rows
I'm trying to count the numbers of "text a" appears in an entire column. This is the formulas I'm working with, that both produces an unparseable error are: =COUNTIF(contains("Resident Instruction", [Resident or World Campus Offering])) =COUNTIF([Resident or World Campus Offering], ="Resident Instruction") What am I doing…
-
Merged: When Copying or Moving Rows, Let us Choose Which Columns to Move Don't Just Default to All …
This discussion has been merged.
-
Is there a way to format numbers from decimal into fraction like excel does.
I am in construction and the need for fractional formatting is very important. I have seen other community questions from 2017 regarding this but has not been updated. Will there be an option for the formatting soon?
-
Text to columns in Smartsheet
I have a cell with multiple values separated by commas. (eg. A, B, C, etc.) I want to try get these separate values in a column: eg. Row 1 - A Row 2 - B Row 3 - C and so on.. PS. There is no limitation on how many values this cell has. It can vary from no values to up to 40 values.
-
Dynamic view @mentions - email not to take the user to the underlying sheet
the email notification to the @mention take them back to the underlying sheet, this defeats the purpose of keeping the user out of the base sheet. When the end user get the email notification, it should take them back to the dynamic view to add the comment.
-
Past Due Date in Business Day Formula
Hi! I have a formula I have been trying to figure out. I'm getting stuck because I want to make sure that the duration does not include weekends or holidays (if possible) and there is a condition. Any help would be appreciated. I would like to know how many business days past due a project is from today, but only if…
-
Using COUNTIFS with CONTAINS
Hello, I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this: =COUNTIF(CONTAINS("Bernie Sanders", [Assigned]:[Assigned]), "True") The return value that I get is "0," which…
-
Merged: Lock Cell
This discussion has been merged.
-
How do you limit items in a dropdown menu field based on the selection of another?
We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example: We have a Job Department field and a Job Type field. If the Job Department dropdown menu includes Accounting, HR, IT, etc., we want the Job Type field to be limited to…