Hi, everyday I'm working with lot data, there is many of columns and even more of rows. And there is no specific function for finding text when several criteria should be used. For finding exact value…
Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever…
I am trying to give a percentage based on how 2 columns read. Column PassFailA and Column PassFailB. If both show Pass 100%, If A is Pass B is Fail or Vise Versa 50% and if both Fail 25% I think this …
Hello there! I'm a relatively new Smartsheet user and I've got an issue with a formula that I could really use your help with. Here's the formula: IF(AND(OR([Initial Draft Due or Task Start]12 < TODAY…
I have two sheets that I want to share information across. Sheet1 contains hundreds of part number records and standard data fields required for each part number. Sheet2 contains essentially a task li…
Please see attached screenshot In a separate field (that I haven’t yet created), I would want to know the % availability (based on 40hr work week) of each assigned resource based on each active reques…
Hi, I found 2 templates on smartsheets for time off, but neither work, and I have attempted to customize to my needs and I am not able to figure it out. First I want a form that employees can submit t…
I am working on a project plan that needs to show the "health" of each task based on the finish date and the status. I've been able to do a formula that checks the status and then selects the correct …
