-
Formula to find data in table with multiple columns based on 2 critera
I am looking for a formula that will look at this table and pull the hours per week based on 2 criteria – group and week. Right now, I have the tables separated so that I can use a vlookup formula. But that means I have to have 5 different formulas, 1 for each group. =IFERROR(VLOOKUP(ROUND(($[First Receive]@row - $[Week 1…
-
Automation Not Working?
Hello, I have an approval path for update requests. It starts with a form, and it currently isn't being received after being handed off by the PCM. So, starting on page 3, the Area Director isn't receiving the update request. I have myself filled in for most of the steps which will be changed once I get this sorted, but…
-
Data deleted in error earlier today, can I get it back? (Undo button not active)
Earlier today it looks like several columns of data had the "clear contents" action taken in error. Is there a way to get that back other than using the snapshot feature and manually adding it back to a sheet with conditional formatting etc.? thanks in advance for taking a look1
-
Cell Linking
I have a inventory workspace. I am trying to set it up to link a cell on sheet a to a row on sheet b. The purpose is to set it up so that whenever the quantity on sheet A changes (no matter the cell), the quantity adjust on sheet B (for the entire row). Is this possible?
-
Formula not working - need help please - showing as incorrect argument
Can someone please help on the below formula - it is not working and showing as incorrect argument - I want it to take into consideration both the month and the year - if it past or later than the proposed service date then i want it to show its late via 'YES', blank if its blank and if its in date to show as N/A - the…
-
I cant open any of my sheets
-
automatically updating created date on a sheet
Hi, I am a new user and trying to work out why my pre start form I copied from another worksheet wont update the date etc in a new worksheet. I duplicated a sheet from one workspace to a different workspace. It is a sheet with a prestart checklist that in the original workspace, once its filled in it puts the days date and…
-
Predecessor #REF Error
a PM asked me to look at his schedule because one of his predecessor cells had #REF. We can't figure out why this is happening because he references line 176 in other cells in the column. When I went and looked at the schedule on my computer, the #REF error moved to a totally different cell and I don't see it in the same…
-
Publish Sheet with set layout
It would be great if you could set the layout (column widths, width of Gantt panel, hidden columns etc) for a published sheet and for that to be independent of latest saved layout of the sheet itself.
-
Multi-part calculation
Hello. I have an "intake" sheet in which I now have a calculation sheet in order to start putting numbers on a dashboard. What I'm trying to do: Set up a formula where Smartsheet will (for example) sum the Units sold only if the Year is 2026, month is 1 and City is New York. Smartsheet has been hitting me with a "0" when I…