-
How can i create tabs in my Dashboard/Portal?
I watched the introductory video about Smartsheet on youtube and witnessed an amazing feature but I do not know how it was created. She had multiple tabs in her dashboard that functioned just like tabs on a web browser. Here is the link and time stamp of her using it. https://youtu.be/uGRFFavDm4Q?t=1524 . I have made…
-
Date calculation formulas are not working properly.
Hi, community. I have a weird problem with my metrics sheet and the dashboard linked to it since it is displaying fault information with a specific formula. I have tried a lot of workarounds, including the update of both source and metrics sheet and a lot of different formulas but I can't still fix it. Formula is as simple…
-
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…
