-
Average Days
I am looking to have some metrics set up on a dashboard all around average days to close. I have a column for a sales person, two date columns (one a start date and one a close date) and a column called Workflow Status. How can I do the two following things via formulas: * Filter this first by the workflow status being…
-
Phase of Work Formula
Hello Community- I am looking for help with a formula to tell me what phase of work the project is in. The formula will be looking at 5 checkboxes in columns. If I complete the last checkbox in the first phase, but have not completed the last 2nd phase checkbox, I would like the column "Project Phase" to return the 2nd…
-
Export of Reminders
If I have multiple reminders set up in my Smartsheet, is it possible to get an export of all the set reminders together with the content/message I have written?
-
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…
