Everytime I add a new row in my sheet, I have to go in and make the formula go onto that new row. Is there a way to have the formula auto-populate whenever I add a new row into the sheet?
I would like some help trying to figure out a "VLOOKUP" formula. I am trying to get the circled number on the attached file to go onto another sheet. I have tried all different ways and I cannot seem …
Hi everyone, I have had smartsheet for awhile and finally taking the time to learn/use it and am stuck. I have a custom apparel business and have made a sheet to keep track of all my orders and what t…
Hi, can anyone help with the formula for the following required outcomes? * $0 if the management agreement has not started [Mgnt Start Date], * Equal to the chargeable amount [chargeable amt] if the M…
=IFERROR(NETWORKDAYS([NAI Project Start Date]7, [NAI Project End Date]7), 0) Cannot get this to calculate The first field has =Another_Cell but the property is set to date. Is this the problem? Im tes…
Hi all! I need to fix a column in Smartsheet. The column that says "# of days outstanding" does not always automatically fill for us. How do I fix this, do I have to put a formula in each cell? Also, …
I created a project request form for one of my team members -- others on the team enter a request by filling out the form, and so the sheet becomes his workload queue. Another team member has a schedu…
I believe this formula should work, and when I break it apart it seems to work but doesn't when together. Copy from sheet =JOIN(COLLECT({Range 1}, {Range 2}, IF($[By Shift]$1 = "All", @cell = @cell, @…
I am attempting to automate my project list by scoring each project based on calculations in another sheet. I would like to create a "Project Score" based on drop-downs in my project sheet. Sum=Comple…
I am trying to create a formula to look at multiple columns and count if they meet a specific criteria. I have a formula that works when there is data in the sheet but it causes an error whenever data…
