-
Formula, IF Statement?? Escalation Status
I want to add a formula; The criteria is as follows: IF "Actual Implementation Complete Date" = BLANK AND "Target Implementation Date" is 14 (business days) (greater than or equal to) to than "Escalation Status" = "At Risk", otherwise "Overdue"
-
Copy Certain Row Cells to New Sheets
Good morning! I came across this thread (https://community.smartsheet.com/discussion/92237/copy-specific-columns-from-one-sheet-to-another-linked) but it doesn't look like it's had any traction since early 2023. I'm hoping this is still something that is in the works and figured I'd see if anyone has come up with any work…
-
How to do Auto Numbering Parent and Children rows separately?
Hi Smartsheet community! I have an issue. I need to use parent rows as separate projects and children rows as its tasks. That is why I need to have auto numbering separately for projects (parent rows) and tasks (children rows). Currently I use the "Auto Number" function. The only problem is that it does numbering of parent…
-
Anyone know how to turn these notices off?
It is quite disconcerting to end-users to think they don't have the best or that they need to always be upgrading. How do we disable or deactivate these banners? dm
-
Desktop app appears in a small window !?
Hello, The desktop app (Windows) that I have just downloaded cannot be enlarged on my screen. The window button (red arrow / see attachment) cannot be clicked!? (Window 1920 x 1200) Quite strange. Have I done something wrong? Thanks for help - Marc
-
Resource Views not Showing assigned tasks
I have a Smartsheet with resource management enabled, users that the sys admin set up for three teams, and a resource view by "user" that filters for just those three teams. Yet still the assignments do not show up in resource view! I cannot figure this out. Here is the view on the sheet to show those tasks as assigned:…
-
Cross-Sheet MATCH INDEX ERRORS
I am running in circles trying to solve this issue - seemingly, in using MATCH() on an external cell reference, the value it returns caps itself at 14 even though data goes out to ~30. While I end up using this base function in much larger equations, the screenshots explain the basis of the issue: Here is the Cell…
-
Pulling cell data based on date and name
Hello, Could someone help me with a bit of a pickle I can't get around? I have a sheet with multiple dates and names and their daily progress. The dates are pre-populated for the entire month with everyone's names assigned for each day. I've been trying to figure out how I can extract the status percentage for a specific…
-
SUMPRODUCT Workarounds?
Hey all, I'm evaluating Smartsheets for my business and trying to determine whether workarounds exist for some necessary calculations. Three big ones are cost calculation, weight calculation and inventory management. I currently use Excel for these. My arrangement is I have all our products on the top row, with all of our…
-
Sequential numbering not working (Project with WBS sheet)
Hi All, I am fairly new to Smartsheets, so please be kind :) I am creating a WBS with the Template the Smartsheets provides (Project with WBS sheet), but I am noticing that when I add new tasks between other already created tasks, the numbering goes all wrong. Also, Even if I add more tasks underneath, the numbering is not…