-
using dates in countif formula
Hi all, I have an issue, I need to use a collumn with autonumber system format, in this case i have used date. the problem ocurres when i need to count all rows created in a specific date, it seems that the systems does not count the dates with hours after 5:00 pm or assignes the next day date if the hours surpases 5:00 pm…
-
Box >> Tableau Integration
Is this possible to have a Box to Tableau integration with Smartsheet at all? I understand that Smartsheet can have attachments connect from Box (that should update in real time), but is there anyway to actually populate the SmartSheet with the values in a file on Box? I only ask because it looks like the Data Connecter…
-
Search using wildcard* not locating content in a sheet
Hello, Today a user asked how to make the searches in a sheet less restrictive. I offered the wildcard as a solution and as we were walking through the search it found 0 results. Within the sheet I have a column with a customer part numbers including revision example: 111-111111_RevA. I perform a search for the part number…
-
sum time total time reported today per production line
I have sheet that is being populated by data being entered into a form. I have columns for "Date" "Production Line (text field)" and "Stoppage Length (time)" I am trying to come up with a formula that enables me to sum the total stoppage length each day per production line. I created a formula that uses the sumif formula…
-
Issues with Smartsheet connectivity
Hello, Is anyone else having issues with connectivity? I am able to log in but when I start to work on my webform, it locks up. I had this issue last week and tech support said others did too. I sent 3 notes to tech support and have not yet received a response. Does anyone have any ideas about what is going on?
-
Revenue per month Formula extending beyond 1 year
I have a sheet that I have created to forecast revenue per month based on forecasted schedules and dollars/project. Currently this just goes for 1 year, but with projects now starting late Q4 2017 and going into Q1 of 2018, I am needing to revise this formula to add a year definition. Would love if someone could take a…
-
Conditional Formatting - Not working for updates / new cells
All of a sudden conditional formatting (colors) of cells when a specific list option is selected on a cell update or when a new row + cell is created. The conditional formatting rules are working for existing cells, but not for above. I've tried deleting the rules and re-creating them, clearing formatting in the column,…
-
autofill linked cells
I have a Master sheet with job rows that number 1to17, next job starts on 18 and are the same rows of data. These continue as such for subsequent rows. My other sheets link to certain rows on this Master. For example row 17 is always "Shipdate", so my "ShipDate" sheet links to row 17 on each job so I can have a calendar…
-
Programme RAG
Hi All, I have a roll up sheet for the programme of work, each line is a project that is being worked on or queued for work. Each line has an Overall RAG called ''Overall Status''' for the overall project and I have a metrics table which states the Programme RAG, currently this RAG for the Programme would be manual, i…
-
Vacation/Out of Office causes resource over allocation?
I hope someone can help me out here, or tell me how they approaches this :) In my department we have some issues when people are on a project and then going on vacation or out of office, it will show as if the person is 185% over allocated. (for example if it is 85% project and 100% vacation) Is there any workaround on…