-
Is it possible to count if a cell changes?
Hello! I am trying to calculate the amount of times a cell dropdown is changed per day. Is this even possible or would it need some magic workaround? In any given day the "current stage" column changes possibly many times. An example question would be: how many times did a cells in "current stage" column change from "Art…
-
Smartsheet Forms - hiding headings
Hi, I have created a Smartsheet form and require participants to ticket a box before questions start appearing. I would like to also apply this rule to the different section headings I have, as at the moment the section headings appear when the user opens the link, but the questions don't, therefore making the form look…
-
How you do get an automation to send an "Alert Someone" email.
-
Count(Distinct()) function that works with one column (range), but not another.
Hi All! I am using a =Count(Distinct({Range})) which works exactly as expected with one range of data, but returns a "1" with the exact same formula on an adjacent column of data. The only difference between the data in the 2 columns is the data. Same column type, similar numbers, etc. Anyone had this issue before?
-
Can a user request an Update Request?
I'm using a form to collect shift information from employees (onto a master tracker). This shift information is filtered to 10 different reports, depending on the building and department. I need the user/employee to be able to modify their requested shift after they have submitted. The Update Request feature works but I…
-
How do I show health based on end date & % complete?
I'm trying to show health of a project based on how far out from End date + how much of the work has been completed. Green: 100% complete before or on End date Yellow 70-99% and today is < 1 range of End Date <69% and date within 2 days of End Date Red <69% and today is <1 range of End Date This was what I wrote, and I…
-
I just deleted Columns in a Smartsheet and I have no backup
I thought I was in a Report. BUT I was in a filter and I deleted several columns from a sheet. I do not have a backup. In the recent history it will not show the data in the columns either. HELP!
-
COUNTIFS NON Blank Question
I have two columns, "Assigned To" and "Date Entered". What I want is to count blank "Date Entered" cells that are assigned to a specific person. Is this possible?
-
The 'Send' and "Send Update Request...' functions are not working for our licensed users.
Did something change? We rely quite heavily on these functions. Any insight would be appreciated. Thank you very much!
-
How to automatically copy the approved documents into another grid or sheet?
Hi, I have a grid or sheet where the rows which document status is already "SPC-approved" need to copy or populate to another sheet called "Approved Docs". Is there a way where this Approved-Docs sheet can automatically copy or get those rows with "SPC-approved"? Please lead me to an idea like formulas, automation…