-
How to show resource allocation from multiple sheets including Leave calendar
I have just discovered Resource Views, which allows me to create a %Allocation column in my sheet and display %Allocation per Assigned users. I have two sheet which have set up the %Allocation, 1. "Pipeline" and 2. "Leave Calendar". However the resource allocation sheet in Resource views is only picking data from my…
-
Can a Report be Dynamic?
Is there a way to dynamically change a report using a drop-down field in the report? For example if one needs to report on "projects completed in quarter x", can there be one report, with a field the viewer can toggle to choose between values like "2021Q1", "2021Q2", etc? Or do I need to create a new report for each…
-
IFERROR for VLookup
Hi, My understanding of formulas is very limited. I have a basic Vlookup and I want the #NOMATCH to instead show as a '0' or an 'X' symbol (given I am using the tick, hold, x symbols). My current Vlookup is =VLOOKUP([UNIT CODE]@row, {CPA Marking list Range 1}, 10, false). Can someone help amend this so the outcome of…
-
Can I add a table to a form
In a form, I have a text field that a user can fill in with product information. What I was hoping to do within that one field was to have a table, so users can format the information in that response correctly? Please see attached image - what I want to appear is in red. If this is not possible is there a different way to…
-
Formatting Column of Numbers To Text
Hi there, Is there a option in smartsheet to format a column of Numbers to Test? Anyone please assist. Thank you!
-
Automatic Sorting by Value
Is it possible to automatically sort rows within a column from highest to lowest. Ex.) If we are adding scores into a Smartsheet, can the sheet automatically sort all new entries after we refresh the sheet?
-
Gantt Bug in Dashboard?
When I view the Gantt chart directly from a Report it goes to today as the starting point for the chart (I've selected that option in the Timeline setup). But, when I display that same report in the Dashboard, it doesn't honor this setting and instead displays the earliest date in the Gantt timeline (which in my case may…
-
User icons grey out
Hello, We've notice that about half our users no longer have their initials show up as part of their user icons, and instead these appear to be grey out. All of them are still active and we have not changed anything. Anybody else have this issue and a fix? Cheers, Atish
-
Sorting in a report
I am filtering information on a report by Start Date in between Jan 1 and Dec 31 of 2022, start date is in the future, and in the next 120 days. Grouping it by month (January - December). This is populated by a helper column formula that takes the month from the start date and converts to the month. I am grouping the…
-
Move/Copy rows between sheets
Hi, I'm using move rows action to archive completed task from one sheet to another archive sheet. All works just fine. In the archive sheet I'm adding more columns, related to the archive. Now I got request to send some selected rows back from the Archive to the original source sheet. Is there any way to select which…