-
Counting overdue on multiple sheets
I cannot for the life of me figure out how to get the overdue which is in a date field in red text, counted on multiple sheets and only if its not complete, or not cancelled - everytime we try, it get 0 which is inaccurate =COUNTIFS({Exp_Status}, <>"Complete", {Exp_Due}, <TODAY())
-
User Interface to collect smartsheet data
I have a smartsheet with data, I would like create a UI for other people where when they just type one of the specific data (such as name) and information about that row pops up without even opening the smartsheet. So it is easier and quicker to retrieve data.
-
Export formula to Excel
I am trying to export a budget sheet that has formulas to Excel and still have the ability to manipuate the numbers with the same formula, but it does not carry the formula with the export. Is there a way to preserve that formula during export? or is there some other way to export the data and keep access to the original…
-
Replacing form entries instead of copying
I have a smartsheet with a form automation that collects information like a survey. However I want to make it so when an entry with detail such as name is already in the smartsheet it replaces it with the new form data rather than creating a new entry.
-
Parent Task to Child Task Automation
Quick Question; Is there a way or work around in automation such that when a child task is past due, the parent task status can move to "At Risk"? Seems like something that should be simple, and maybe it is, but I'm not able to develop a work around. Thanks in advance.
-
How do I make a form field's visibility dependent on 2 fields?
Hi, I've been struggling with this with my favourite AI for over an hour now and I've hit a wall. I want to implement the following: if [CheckboxA] show field 1 if [CheckboxB] show field 2 if [CheckboxA and CheckboxB] show field 3 There is no way to do this within SmartSheet forms. You have to have a helper column in the…
-
How to transfer a sheet from an Owner who no longer exists
We have an account in SmartSheets that owns sheets as an Owner. However, the user does not show up in our users list, so we cannot delete. To further explain: As part of a new business acquisition, sheets were moved by Business A to new Business B using this account. Once all sheets were transferred, the Business A account…
-
Receiving multiple emails from single workflow
Good morning and happy Friday! I'm hoping someone might be able to help me figure out why myself and others are all receiving multiple emails when a workflow is triggered. I did recently move this particular smartsheet from Sheets to Workspaces, so maybe that caused an issue? But what's happening is, I have an approvals…
-
Esc key now equals refresh?
As of today, October 7, 2024, any time I press the Esc key, my sheet automatically refreshes without the option to save. This happens while editing cell data, editing column properties, anything. It will automatically reload the current sheet and not give me an option to save. Is this something that Smartsheet applied, if…
-
Automatic numbering for Work Breakdown Structure
Hello , Does " Automatic numbering for Work Breakdown Structure " exist in SMARTSHEET ? It's been a couple of days now that I am searching for . Can someone help me ?
