-
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…
-
Templates
Just watched a training video , and he showed a template(s) named "Weekly Task List Template " and "Daily Task Manager " cannot locate this group of templates anywhere ?
-
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…
-
Automatically Sort Rows in Sheets
As rows get added & cell values change, it would great if we could automatically sort them in the sheets themselves instead of having to set up reports. Adding the ability to do this in a workflow would be a fantastic addition. Right now we have to do it manually.
-
Video Editing Software Discussion in Smartsheet Community
Hello Smartsheet Community, I wanted to kick off a discussion about video editing software, and how it can complement our project management efforts in Smartsheet. Here are a few topics to consider: Favorite Software: What video editing tools do you use? How do they integrate with your projects in Smartsheet? Tips and…