-
Document Builder - Adobe Calculated Fields
Hello community, I am currently loading a PDF that was made using adobe acrobat pro into the Document Builder as a template. There is a date field that always needs to default to today's date. I currently have the field calculating off the following script: var today = new Date(); event.value = util.printd("m/d/yyyy",…
-
Elapsed duration is calculating one additional day
if I use e10d in duration column to ignore non working days its calculating one additional day, for example if I set the duration as e10d and the task start date is 01Dec2022, the end date should be 10Dec2022 right but its showing 11Dec2022 as end date.
-
"Ticker Tape" Feature on Dashboards
Could a "ticker tape" feature be added to dashboards so that we could add important news, announcements, callouts, etc., that stream across the top or bottom of a given dashboard?
-
Dynamic View Detail Panel not displaying selected fields
I have a Dynamic View built from a report with 59 columns. The original sheet has 130 columns. I set up the Detail Panel to display 19 of those columns. I do not have any conditional formatting set up and none of the fields are hidden or required. When I click into the Detail Panel, it is not displaying some of the columns…
-
Count weeks in a Cycle
I know there is a function for counting weeks based on the start of the year. Is it possible to count weeks from a specific start date, instead of from January 1? For example, I might have 12 weeks in a cycle of a project, and would like to show (on a dashboard) that we are in "week # of 12 weeks" in a specific cycle.…
-
When a new row is created in smartsheet get the data from that new row and use it in Power Automate
I have a Smartsheet sheet which is populated using a Smartsheet form. When the form is submitted it creates a new row in the Smartsheet and inserts the relevant form data into the corresponding Smartsheet columns. I now want to use the data from that row in a flow in Power Automate. I am using the "When a new row is…
-
Impact of deleting/removing a user
What is the impact of deleting a user if they were previously an owner of sheet and groups? (Note; I have already transferred all of their items to someone else, but they were the original author of these sheets and had input (row entries and comments alike) . I don't want to lose knowing what they did in the past in case…
-
Open all Smartsheet hyperlinks in new browser tabs
Hi Community, Is there a command or shortcut that will open all Smartsheet hyperlinks in new browser tabs? I wish to test if there are any broken links. Thank you!
-
Dynamic View Tricks for Common Painpoints
I've been using Smartsheet's Dynamic View to streamline and automate workflows in my organization, which has led to stakeholder onboarding that has scaled to a large group of external users. There are common complaints that have surfaced from both new and existing users, which makes me curious about workarounds the…
-
'Most Common' Formula
Hello, I am trying to create metrics on tracking the versions of an applications we are developing, currently I am attempting to find which version is most successful after it has been run through a series of criteria. Example: Build 30 - Success Build 31- Success Build 31 - Failure Build 32 - Success The Application…