-
IF, CONTAINS, NETDAYS, AND, CONTAINS
Hi all, Trying to use a formula to work out net days between events in a column (Visit End Date) when a second column (Visit Description) contains "V" but also only if the last visit also contains a V. =IF(CONTAINS("MV", [Monitor Visit Description]@row), NETDAYS([Monitor Visit End Date]1, [Monitor Visit End Date]2)) worked…
-
URGENT - CAN'T CREATE NEW ROWS/CARDS
Hi, We wanted to report an issue we have been experiencing today with our files in Smartsheet. When trying to create new rows/cards through forms, the data did not seem to be saving — the files would load while filling out the form, but after submitting it was as if nothing had been done. After running further tests, we…
-
Operational issue due to new licensing restrictions - seeking ideas
Hello! I'm seeking ideas / work-arounds / the right language to convey the barriers and suggest enhancements in response to the new licensing restrictions. Here is my context. I used sheets to format a 'clinical trial transparency report card' (image below). This sheet curates institutional data from ClinicalTrials.gov…
-
Integrating Smartsheet Reports, Power Automate and Smartsheet API
Manual task automation isn't just about saving time; it's about building a reliable, repeatable, and secure pipeline. We recently took a standard user-provisioning process that previously required 15 to 30 minutes of manual administrative effort per run and reduced it to a 1-minute automated execution. By connecting a…
-
Automatically Setting a Future Date Based on Criteria
Is there a way in Smartsheet to automatically default a date column to 30 days in the future based on certain criteria? For example, if Column A has a value but Column B is left blank, can Column B be set to automatically populate with a date 30 days from today? I tried creating an automation where the trigger is when…
-
Automation not triggering
Hello Community, I am having issues with an automation not firing, not sure what is tripping it up: Also I am unsure if I should see the Update Request icon highlighted in the left margin, when this fires? Of course if I manually click to send an Update Request, it does highlight, but I am trying to set this up so that it…
-
Ability to Include selected fields in Smartsheet Notifications - With out the Link to SMARTSHEET.
It would be great to have the ability to exclude link to the smartsheet while including smartsheet fields in smartsheet automated notifications. This is because we want users to use dynamic view instead of directly accessing smartsheet. With dyamic view we can control what they see and what they can edit.
-
How do the hours work in the “Report time for something else” feature?
I've been trying to use the “Report time for something else” feature in Resource Management, under the Time & Expenses tab. However, even when I assign hours to a project and those hours are approved by the approver, no task appears in the Schedule tab. How do these hours work? Do they only affect reports? Where can I view…
-
Can we add chatbot or AI assist feature when building intake form in Smartsheet?
-
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…