-
Show row attachments in report widget on dashboard
When I create a report from a sheet, there is a column at the beginning of the report showing any attachments on that row. When I insert the report widget on a dashboard, I can't get the attachments to show up. I'd really like users to be able to access the attachments directly from the dashboard instead of having to open…
-
Generate Documents - Can contact names be filled instead of contact email address?
Hi there, Hope all is well. Hope someone could help. I have created a fillable pdf to be used with the new "Generate Documents" feature. It works great except for one issue. When I map the "Assign to" field or any contact field, it fills the document field with the contact email address and not the contact name. Is there…
-
UNPARSEABLE Error for Countif of overbudget tasks
Hello all! I'm trying to calculate the number of the overbudget tasks in my sheet summary. I have a column that is Actual Cost, and another column that is Budget. The AI suggested formula was: =COUNTIF([Actual Cost]:[Actual Cost], >[Budget]@row) But when I hit enter, I receive the unparseable error. Could anyone help me…
-
SUMIFS With Multiple Criteria
Good day Smartsheet team, I'm a hardcore Excel user attempting to migrate my skills over to Smartsheet and I'm getting lost in the translation. Attempting to set up a formula to pull specific data into a sheet using SUMIFS. Here's my formula: =SUMIFS({GLData Range 1}, {GLData Range 3}, MONTH(@cell ) = 4, {GLData Range 4},…
-
WBS Numbering Error
I'm not sure if anyone will be able to help with this one, but I am running into an occasional problem that I don't quite understand. Essentially, I have a WBS numbering system running to give tasks an ID, and then using the ID to look up a letter equivalent from another sheet, and using that for the Item Label of each…
-
Smartsheet Build Version
How can I find the product build version for Smartsheet and other products? Thank you, Ron
-
COUNTIF formula help
This discussion was created from comments split from: Using COUNTIF in Sheet Summary.
-
Rolling 12 month column chart
I have a column chart as seen below: The summary sheet i use as the data source is formatted as below: I used a summary sheet instead of a summary report as it gives me more options to manipulate the data, but also structure it correctly in terms of month order. The months and years will have to manually be inputted and…
-
Enhancement to update Data Shuttle to recognize/preserve leading zeros in front of numbers
Use case: Managing hundreds of cloud accounts that have a fixed length ID and a randomly assigned number. Some account IDs have 1-3 leading zeros, some have none, as long as the overall length is 12 digits. Issue: When using Data Shuttle to import updated lists of accounts, existing accounts with leading zeros, are deleted…
-
Row Report - Displayed Sheet Names Do Not Update
I have several (OK, 10+) Smartsheets in a workspace and have put together a row report which filters and only displays the open tasks for each Smartsheet based on the column information. Simple enough. My problem is that will update the individual Smartsheet names to allow for easier sorting, however this takes an…
