Hello, I am trying to make an "if statement" but I got no luck. I don't know how to start, I tried with =IF(sqf1 > "32", "width1*hight1*5.5", "sqf1 < "32""width1*hight1*8.5") I know its looks bad :D T…
Does anyone know if smartsheet has a feature whereby the address can be located automatically by filling in the postcode on a UK Address similar to https://www.parcelforce.com/postcode-finder It would…
Hello Folks, I’m relatively new to smartsheets (3 months) but I’m diving right in creating sheets for a medium size construction firm. My recent project is a daily time reporting sheet for approximate…
Hello, I am looking to use a formula that will check the box of the parent box if any of the children boxes in the same column are checked. Can anyone help with that? Thanks
The function I am looking for would allow for data to be pulled from a source sheet which is increasing in size and be kept in sync for maintaining accurate information. To help explain, at the moment…
I am trying to link two sheets. The main sheet contains all my essential information, however one column has a list of drop down options. If the user selects a certain option from the drop down I want…
Seeking an independent Smart Sheet Consultant to begin work no later that the 31st October 2017 6:00 PM GMT You should be able to screen share and use our already uploaded excel spread sheets to creat…
I am trying to have a column with dropdown choices auto-populate a value in the next column. If IP-A is chosen in the AssetType column, the TotalHours column should display 1. If IP-D is chosen the To…
e.g. =COUNTIFS(Recruiter:Recruiter, "Christie", [Deal Date]:[Deal Date], MONTH(@cell) = 10) e.g. = 50 This is an example of how I identify my "deals" for the month in a sheet which lists every deal my…