-
Turning Off Card View
Is there a way to disable Card View permanently or "shut it off"? Our company uses things in Grid view and we would like to disable the function to avoid confusion.
-
How to create a non-updating widget with key background/info
What kind of widget do I need to create to present basic descriptive text (background information) about a project? I’d like to pull the basic data from a sheet that is seldom updated. The widget would be in a report about a real estate transaction. Background data I’d like to add in widget from the non-updating sheet…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Looking for formula
I'm new to using Smart Sheets and looking to calculating aging date for invoices for tracking purpose. I tried several ones I used for excel but does not seems to work here. I did also use some of the formula's people had suggested on the blogs here but no luck. Please help. What I have is the invoice date and need to know…
-
Sum of Parents
I keep track of pending transactions in a real estate office, and have each month as a parent and the closings scheduled as children under the correct month. On the parent row of each month I've got totals showing for the children. This all works great. What I can't figure out is how to total the parents. At the bottom of…
-
Inserting a Formula into an existing Equation
I have a simple math equation in one of my cells, and in place of one of the numbers I would like to reference a count of cells with dates in them in a certain column. My equation is: =100 - (((60 / 477) * 100)) (this returns a number in a percentage format) and I would like to replace the number "60" with…
-
Populate Start/End Date based on Status change
I use the Card View for quickly creating tasks and tracking their status/state. I'm trying to see if it's possible to take this further and populate the Start Date and End Date fields when the task first enters a specific state. See screenshot attached.
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
If multiple cells are blank or a one specific cell has data
I am trying to achieve this - If the action required by and the data processed is blank or the action required by = "DAT", then "DAT" is the correct response. This what I have come up with =IF(OR(AND(ISBLANK([Action Required by]1), ISBLANK([Data Processed]1)), ([Action Required by]1=DAT)), "DAT") Am not sure how to fix…
-
Enhancement Request - Hidden Columns Manager
Running out of screen real estate is a problem. I find myself hiding or dragging columns to right and then having to unhide them or drag them back into the active area of the screen as needed. Request for a utility that would store preferences for hidden columns that has the same general controls as the <filters> widget.…
