-
Automation Not Triggering On its Own When Trigger Criteria Met
Hi - I am using Smartsheet to manage our cutover plan for a software deployment. I have 2 columns that populate a Yes/No value automatically based on a formula calculation. Those columns are called 'Trigger Date' and 'Trigger Time Comparison'. The 'Trigger Time Comparison' is always the last column to flip to Yes, so I set…
-
From ESRI GIS to Smartsheet
I came across many articles regarding connection from Smartsheet to GIS, but I'm interested in getting attributes out of GIS and into Smartsheet. We have many program administrators need information from GIS and manipulate it to create and track projects.
-
Quick question about submission not showing up on record
Hi all, Part of our workflow for documenting tasks is submitting a form to a supervisor, which they then will approve as completed. This has been done for months with no problems Today I submitted multiple of these, all of which said either "submitted" or "approved" like normal. However, two of them are blank, telling me…
-
Merged: Copying specific columns via automation
This discussion has been merged.
-
Smartsheet Integration with PowerPoint Office Timeline Pro+ Error
I keep receiving the below error when I try to Integrate my Smartsheet with Office Timeline Pro +. Anyone have a solution to this?
-
UPPER formulas
Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
-
Can I create a form that can automatically update a worksheet.
Hi there! I’m sorry, but I’m very new to this platform and still trying to understand how it works. My employer has assigned me a task to improve the use and functionality of our worksheets. He suggested that I explore the possibility of creating a generic form that can automatically populate client worksheets. The…
-
Rounding to nearest Thursday in the past or current day if it's Thursday
Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the current Thursday, if today is Thursday. In other words, the date should always display a Thursday date; if today == Thursday,…
-
Need a conditional SUMIFS formula
Hello, I have 2 grids Grid A: Project Management (used for team planning and communication) Screenshot of Grid A Grid B: Invoicing sheet (used for billing clients). I need a formula to take the information in Grid B and tell me the sum of the rows in the Task 1 column IF the sent column is checked AND the void column is…
-
Dashboard Widget Dividers
Is there an easy way to get a diving line or border between widgets on a dashboard? The only thing we've found is to insert images of lines from Powerpoint - not the best.