-
Hi, I'm trying to reference a cell that contains a dollar amount based on a date range.
This is what I'm trying (unsuccessfully to accomplish) =IF([DATE SUBMITTED]@row >= DATE(2022, 12, 1), [DATE SUBMITTED]@row <= DATE(2022, 12, 28), "PO Amount Including Change Orders" Looking for the amount in "PO Amount Including Change Orders" to show up if the cell "Date Submitted" falls within the date span. Any ideas?…
-
How do you make a name input on a form become a contact that is already a contact in Smartsheet?
I posted this on an old thread, but thought it might be easier to find as a new entry. I am trying to have a contact show up in cells based on input on a form. User fills out form with account manager name. For example, Rachel Alexander. Rachel is in my contacts. However, when the data from the form populates the sheet it…
-
Where is the best place to find help with Power Automate Integration
I happen to be the power automate guru for my team, which isn't saying much. Problem I'm trying to solve: when a cell updates (based on certain target columns), extract that info to a SharePoint list (or some other repository). Why? We have several different project tracking systems and want to consolidate info into one…
-
Copy a range of cells under a parent or ID number to another sheet
We have a wide range of purchase orders which can be created for any job from 1-50. There are about 6 different PO groups I would like to pull data from and assign them to their individual projects in their corresponding rows. Is there a function where I can call the parent and it will copy the parent and children…
-
[QUESTION] What (and HOW LONG UNTIL) Enhancement Requests become Features?
Hi, After using Smartsheet for about a year, I have not found where Enhancement Requests become features in Smartsheet. It seems that there is a chasm of disconnect between the Community's expectation for Enhancements becoming Features and that of Smartsheet. So, what's the process to vet out Enhancement Requests and plan…
-
Harvey Ball Status - Empty is now a blank instead of an empty circle
Hello, I noticed the Empty status of the Harvey ball is now a blank instead of an empty circle. Was there a reason for this change to make this operation less useful? The selections used to be Empty (light grey circle), quarter (1/4 filled), half (1/2 filled), three quarter (3/4 filled) and full (all full). Can we think…
-
Way to use grouping in reports with a multiselect column
Is there a way to group a report using a multiselect column? I have spent a while going thru the community posts going back to when the grouping in reports was released and see that this is something that has been asked about repeatedly with no solution or real work around. We have some sheets that require this…
-
Request maintenance time
Hi, The company where I work we use a Smartsheet intake tool to create and maintain the vendors. As an admin we are facing an issue which is there is no option for maintenance time. Usually banks and other organizations sometimes send email about their site , services are going to be offline for half a day due to…
-
How do I hide the sidebar/shared with bar?
Is there anyway to hide the left sidebar or workspace shared to bar in this new update? I can't see the names of anything unless I zoom out from the entire window.
-
Function to allow the import/export of multiple filters
If we'd be able to export/import filters to be able to share between users this would be an awesome feature that would greatly benefit our office. We have many people looking at the same Sheet but currently if we want to set up filters each user has to create them from scratch. I would think this could be an easy feature…
