-
Sort in sheets
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 implemented to save the time of having to constantly resort? Also, having more than three sort options for a sheet would be beyond…
-
STOCK FOLLOW UP/ FORMULA/LINKED SHEET
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 something back they also fill in the form and tick the 'bring back' box. In the column 'Quantity left' the amount of stock is…
-
How to connect Smartsheet with tableau desktop on Mac OS
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 find an equivalent for that on MAC os , is there anyway i can make it work on Mac, any pointer /links would be highly…
-
Creating a Milestone Sheet (referencing project plan)
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 date with a particular tag, and end=latest end date with a particular tag), its % completion (based on the milestone tag) and…
-
NEW! COUNTIF not blank....
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]))), ISBLANK([Case Closure Date], )) Attempt #2: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case…
-
Unlicensed/Free users - Pro vs. Plan
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 plan has free users, they CANNOT edit sheets that they are shared to (add rows, check boxes, etc.). If a sheet created…
-
Use Formula to Check Checkbox as a Column Formula
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([Column4]@row)), 1, 0) I'm getting a column formula syntax error when I try to apply it to the whole column: "The column…
-
Formula is not persisting when value is removed from cell
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 formula should first check the cell status in Row 4, then change the cell status on the row where the connected cell is…
-
Forced to upgrade
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 to a business plan. I feel this is unethical... does anyone have any thoughts on this?
-
Column Highlight
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.
