-
Function "Current User"
Of course, the information about the current user is already available in the system, after all we can access it via filter. But I miss a function that would allow identifying "Currentuser()" via formula. I'm making individual dashboards and would like to generate personalized statistics for each user, which are…
-
Over allocated resources, no red flag alert
I allocated 100% allocation for the same resources in both projects as an example, projects CMDB and GXP Shutdown. How come I didn't see the red flag in column "Risk" to indicate that the resources are over allocated. Please help. Thanks, Kathryn
-
Editable Font Size and Colour for Data Labels on Charts
It would be helpful to have some control over the size and colour of data labels for charts. e.g. if your dashboard font sizing is consistently a smaller or larger size than the default for data labels, it looks untidy, often data labels appear too large on a chart as a result of the large default font size too.
-
NETDAYS returning #INVALID DATA TYPE
Hi - I'm trying to calculate the number of days between two dates in a sheet. I have both of my columns that contain the start and end dates set up as DATE column type. They both contain dates. I use the formula "=NETDAYS([Hotel Check-In Date]@row, [Hotel Check-Out Date]@row)". I have tried making the results column a…
-
Auto Generation of Crossreferenced tables
Topic: New Sheet Row Generation with selected data from a source Sheet with data linked. FYI: I posed this @ Product Ideas too. If you are used to ERP linked data tables you may have explerienced the need to get similar benefit in Smartsheet. We are in the need to generate a new row in a "destination sheet" triggered from…
-
Smartsheet Enhancement Request: Snapshot/Print Workflows
I have made several workflows that were fairly large for different applications in smartsheet. I would like to have a simple function to print/pdf the workflows so as to see all of one at once. This would help me with design, troubleshooting, and communicating the process to those involved in it. I have submitted an…
-
#Invalid operation error for summing values
Hello Team! I have a weird case, but let's go straight to the point. I have a simple formula: =SUMIF([F Tracking ID Number]:[F Tracking ID Number], [F Tracking ID Number]@row, [X ASIN Value (CI)]:[X ASIN Value (CI)]) which basically sums values from column X for duplicate values in column F. The formula works fine for…
-
Override Ability on Max # of Columns to be Deleted at One Time.
As Excel doesn't have this limitation, neither should Smartsheet. Please allow a confirmation dialog to override. When importing from Excel, I'm left deleting five columns at a time for 5, 10, 15 minutes.
-
Merge all attachments of a sheet into one PDF?
Is there any way to automate merging all of the attachments of a sheet into one PDF? I was thinking of using zapier or Microsoft Flow but I haven't been able to figure out a good and simple way to. Ultimately I want the end users to be able to do so with only one trigger (after the sheet has all of the attachments.) Thanks…
-
Hyperlink for mailto: in Reports, Dashboards and Grids
I've seen this topic come up a few times now, but couldn't find an enhancement request submitted. It would be nice to have the ability to link email addresses in Reports, Dashboards and Grids. The dynamic contacts in Smartsheet is a nice feature turning email addresses to a standard First/Last Name, but could we add the…