Good afternoon, Oh, how I long for sorts within a Sheet to be saved like it is in reports!! We have a set sort we need, but it gets undone throughout the day by other users. When will this be implemen…
Hi everyone, To improve our warehouse we are making a stock tracking. It works like this: When someone takes something from the stock they fill in a form and tick 'use something'. If they bring someth…
Hi All, I am trying to create a connection to tableau with my smartsheet to pull data into tableau , I am able to do this in windows os using the smartsheet live data connector, but i am not able to f…
Hi All, I have created a project plan in Smartsheets and am tracking milestones using tags How do I create a separate sheet which only shows me milestones, its start/finish (i.e start=earliest start d…
I want to count how many columns have a date in the "SMD/IME Appointment Date" row and where the "Case Closure Date" cell in that column is blank: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]…
Based on everything that I have read online via forums and smartsheet's informational material, unlicensed/free users in pro vs. business plans have different abilities. If a sheet created under a pro…
I found this formula in the community that works perfectly to check the box if there is any text in certain cells. =IF(OR(ISTEXT([Column1]@row), ISTEXT([Column2]@row), ISTEXT([Column3]@row), ISTEXT([C…
Hello, We are having an issue with cell formulas. The cell formula is erased when we change or delete a value in a cell. Here is the formula we are using: =IF(Status4 = "Complete", "In Progress") The …
I had recently bought a Pro plan and after about a month, a lot of the features that I had been using frequently (which was available on the pro plan) are blocked and now I'm being forced to upgrade t…
is there the ability to colour in a column not a row to show for example UK bank holidays or staff holidays etc.. to show in a very quick visual way any clashes that might be avoided.