-
FILTER A REPORT ON MOBILE APPLICATION
Hi, I am interrested to know if we can filter on report on mobile apps. I explain, on computer we have the possibility to choose filters by Where, Who, What, and/or. It is really helpful to have an activity follow up linked to many sheets. On mobile, for the same report, I don't find the way to do it. Do I miss something…
-
calendar and linked registrations
Has anybody used SmartSheet to mass distribute a calendar with multiple events shown and connected independent links so people can select and register for each of the separate events?
-
Dashboard formula counting rows within date range
First post, Longtime SSheet user but new to formulas and stuck on this last one for a dashboard. I am trying to count rows where the due date is within a range, the form created date is within 14 days of the due date and the status is not "complete." I have tried a wide variety of solutions. =COUNTIFS({FAMS Marketing…
-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
How can I take a concatenated string and feed it into a form as an option?
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this.. 2019_Jun_Fab5_Skyworks…
-
Pull data from excel and update Smartsheet
Hi everyone.. I am new to the community..so hopefully my question is not too stupid :D I am currently using Excel to calculate a value by using the normal distribution formula. I would like to pull this value from excel and then update a cell in Smartsheet. It is an on-going exercise so the fetch should be done regularly…
-
Referencing another sheet for selective information
Any help with this would be appreciated. I haven't been able to come up with a formula that would check a reference sheet for a value and pull the data from another column to populate the current form. I expect it would be a compound formula with an IF and maybe a INDEX, but I'm having difficulty narrowing it down. - Any…
-
Conditional Formatting if Calculated
Greetings, yes, here's another post about conditional formatting. I swear that I have searched and cannot find the answer to this, so... I have some date fields that I've calculated based on another (30 days after X date). I'd like to automatically format these calculated cells so I can instantly see which ones are…
-
Ideas on transition between annual project tracker sheets
Hello, I am looking for a way to "connect" two Smartsheets that track a variety of projects (one for 2019, one for 2020). Curious to see if anyone has done this, recognizing that some work may extend into the next year, and if there are any lessons learned / pro-tips in creating and maintaining such a concept. Thanks for…
-
Simple team-member tracking calendar
Members of our department are allowed to work remotely two days each week. We want to set up a calendar where we can show which days each of us will be out of the office. In most cases, each of us will have the same two days each week, but we can change if needed. I created a new document and went into the Calendar view,…