-
Formula needed
Hi The numbers are my location in the warehouse Need to have a formule to know how many places i still have in my warehouse. In this example 1 have 2X 0 so means 2 place still free Thanks
-
Moved: Automation of additional line items and events once original event date created
This discussion has been moved.
-
COUNTIFS not working correctly
I wan to count the number of projects that meet these criteria: Maintenance project, not an improvement project Not canceled (so status could be "Completed", "In Progress", "Not Started", etc. Matches a term code (e.g., 202110, 202090, 202060, etc.) Here is the formula I am using: =COUNTIFS([Project Type]:[Project Type],…
-
Grammarly and Smartsheet?
This discussion was created from comments split from: Spell Check in Free Text Fields on Smartsheet Forms?.
-
Asset register report/dashboard showing latest child row data only
Hi there, I'm trying to build an asset register in smartsheet with parent rows for the initial addition of the asset record and then child rows to record any future tickets logged against that asset and the corresponding asset status (so the asset history can easily be tracked). The objective is to provide customers with a…
-
Sync SmartSheet Cal to Mac Outlook
Hi Team, I wanted to suggest a way to enable direct syncing of SmartSheet calendars with Outlook on Macs (this functionality is only available on Windows at the moment, https://help.smartsheet.com/articles/775707-publishing-a-smartsheet-calendar-to-ical). Currently, as a workaround, I’ve synced them via Outlook.com, but…
-
Need another option than INDEX MATCH
I am trying to pull data from 2 columns in one sheet into another (a name and a date) which worked great until there was another instance, which know I find out that INDEX MATCH can only see the first instance. I am looking for other options. Below is a quick example: Formulas being used are in bold and underneath are the…
-
Allow Gradient Conditional Formatting like Excel
Would love to have the ability to easily implement conditional formatting using a color gradient like you can do for excel. I know there are workarounds to achieve this, but would be helpful to have the functionality built in.
-
Dashboard's Widgets random blackouts
Hello, I'm currently facing an issue, I have implemented several Dashboards in cotrol rooms on a chemical plant. Since a few days, the widgets randomly refuses load. When I reload the page several times, suddenly they all appear, but after an automatic update (typically 10 minutes), some widgets seems to blackout. And on…
-
#UNPARSEABLE using COUNTIF and cross-sheet reference in 2 colums
Struggling and would appreciate any guidance…………. I have a huge Master sheet and I have created separate metrics sheet to be utilized in a dashboard. In the Master sheet, there are two separate colums, one for various departments and the other for Approval status of PO's. In my master sheet when i run the formula below it…
