Hi, is there a possibility to display 2 logos at the sheet level? I know that I can include a logo image to the workspace and that will replace the "smartsheet" logo from all files within that workspace. But what I am trying to do is to personalise at the sheet level because within the same workspace I have sheets that…
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…
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…
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?
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…
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 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!
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?
Did something change? We rely quite heavily on these functions. Any insight would be appreciated. Thank you very much!