- Certified Smartsheet user on the look out
Hey friends, Anyone hiring experienced Smartsheet user, if so let me know! I've been using Smartsheet for 6 years, it's so much a part of my daily work productivity and I'd like to seek out another opportunity where I could transition my skills and background in program management into. I've gain so much knowledge and…
- Software solution using Smartsheet
你好,我的experience thus far with Smartsheet has been as a Systems Administrator for the last four years. Prior to my even learning Smartsheet, I had this idea for an app that would help to streamline a very specific business practice within the higher education industry. The thinking was that I needed to have someone…
- Smartsheet University Is Here!
Hi Community, We are excited to introduce Smartsheet University, a single platform for eLearning, live instructor-led training, in-person training, and custom training. Smartsheet University offers unique learning paths and meaningful content that focuses on the knowledge and skills that matter to you, your industry, and…
- IF Cell Contains This Text VLOOKUP
Hello, The Status Column has a dropdown menu with multiple options with the text "Completed" and some other options: Completed awaiting Signature Completed Reviewing Completed Approved Failed Inspection I want this formula to work with any options from the drop-down menu with the letter completed. This is what I have so…
- Is there a function that counts a cell if it contains a value rather than equals that value?
Is there a function that counts a cell if it contains a value rather than equals that value if you have cells with "dog", "cat", "cat dog" and you want to count "dog" using excel you can use this formula =COUNTIF(A1:A3,"*dog*") but the * doesn't seem to work in smartsheet
- Expandable/Collapsible Columns with buttons (not hiding)?
Is there any capability in Smartsheets similar to this excel screenshot where columns are able to be expanded and collapsed in a grouping using a button? The scenario at hand is supplier contact information being tacked on in several columns at the end of a sheet and it isn't information used on a regular basis but needs…
- Tracking Employee Effort Across 170 Projects
I have a little experience using Smartsheet in my previous role at FSU and am now trying to help them adapt to some (unforeseen at the time) scaling and relational issues on the sheet/form I built. Specifically, this tool has been implemented as a way to track effort/time on a large 5 year federal contract. Our current…
- Cell-linked dates don't go away when I delete the source
I have a sheet (The Milestone Sheet) that is made up mostly of cells linked to another sheet (The Schedule). The 'start date' column in the Milestone sheet is referencing the 'due date' column in the Schedule. I set the 'duration' column in the Milestone sheet to 0 for every row, which makes the due date the same as the…
- CountIf with Date range
I am trying to count the number of requests types between a date range. This is what I thought would work: =COUNTIF(({Request Tracker Range 4 - Request Type}, Category5), AND({Request Tracker Range 3 - Date Requested}, DATE(2019, 01, 02:2019, 03, 14))) I am using this formula to count the entire column =COUNTIF(({Request…
- 编辑显示联系吗?
Hi Do you know if you can edit the display of a contact in an assigned to column? Ideally I just want to see the initials in the icon and not the name/ email that follows. Thanks, Jo
