-
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.
-
404 Error - Event data - Smartsheet API
Hi, I am attempting to get event data from the smartsheet api. First, I tried the new api documentation method which suggests a request to the event api url. Traditionally, you don't pass both a parameters variable AND parameters in the url which is being suggested in the documentation. I tried a few different ways and…
-
Formula: if checkbox is checked then add or subtract
Hi everyone, I would like to have a sheet that tells me how many goods we have left in our warehouse. The idea is that employees report via a dashboard whether they are taking something out of stock or returning something. If one checks the column "IN" or "OUT" they also have to add the amount. That amount should be…
-
Card View for Reports
Any idea when or if we will see Card View on Reports in the near future? If not, I'd like to add my vote for this feature as soon as possible; it would be very useful to our workflow. Thanks.
-
Help with SUMIF Formula
Hey Community, I need some assistance with a SUMIF formula. I am trying to say, Multiply Column 1 by Column 2 IF Column 1 is greater than 1, if not, leave blank. I have tried several different ways but all keep coming back #UNPARSEABLE. Would appreciate some help with this. Thank you in advance!
-
Smartsheet count function
I'm using the count function to count how many times a initial appears in a line and its working great except it won't count a line that has multiple initials in it. Does anyone know how to get it to count that line?
-
VLOOKUP with IF and IFERROR Formula
I need to figure out the VLOOKUP formula within the Barrier Management Survey Status Sheet to where IF the Services Completed is “Door Program” (within the Shared Services Program Survey sheet), and the Facility Name matches, to then pull in Survey Status “Complete”, otherwise (IFERROR) "N/A". This is the new formula I…
