-
Compare a Date column with a static date value and accordingly pass a Yes or No into a dropdown list
Hi, I am new to Smartsheets and trying to set up a formula in Smartsheet that compares the Hire Date (a column with Date type) with a static date of 29 September 2019 and accordingly passes 'No' when the date is older than 29 September 2019 and passes a 'Yes' when Hire Date is later than 29 sept 2019 into a column of…
-
Creating a report by task owner and RAG status
Hello Smart Sheet-ers, I am fairly new to SmartSheet so excuse me if this is breathtakingly simple. I need to create a report of the following in dashboard. I assume from using Sheet Summary. It needs to show Task Owner, then how many tasks that are RAG status red, yellow, green, blue. I'm using the below columns: So for…
-
Creating a report by task owner and RAG status
Hello Smart Sheet-ers, I am fairly new to SmartSheet so excuse me if this is breathtakingly simple. I need to create a report of the following in dashboard. I assume from using Sheet Summary. It needs to show Task Owner, then how many tasks that are RAG status red, yellow, green, blue. I'm using the below columns: So for…
-
Weather icon on calendar view
I have been using smartsheet for several years, and I would love to see on calendar view a weather icon for, al least, one week. Just like Microsoft Calendar. My projects depends on weather, so its pretty important knowing the forecast.
-
Grouping in New Reports
Hi Everyone, The new features in the reports to summarize and group is amazing and has helped us a lot. But I see there no option to group according to "Assigned To" column. Is there any way to do it? I want to analyze performance of individuals over a period of time and I think this feature will help us a lot.
-
No scrollbar on metric widget in Dashboard
Hello, I'm struggling with the following problem. I have created a dashboard to report on a project. In this dashboard some metric widgets are added. The data is filled in by the project manager in the source file. Sometimes this contains lots of information and text, sometimes nothing. Is there a possibility to add a…
-
Will Dashboard editing every include an 'undo' function?
Hi, it's very frustrating when editing text in a widget, that you can't undo. Hoping this is on a list of improvements. Thanks, Louis
-
Is there a way to drag and drop files between sheets?
I have files saved on each line of Sheet A and need to drag/drop the file to a line on Sheet B, but Smartsheet doesn't seem to allow me to do this. Is there an easier way than just saving the doc to my hard drive and then reuploading it to the new sheet? Also, is there a way to do that with a vlookup by chance?
-
Automated Workflow fields - can they be duplicated?
Hello knowledgeable ones, I have multiple workflows for approval/assigning within one sheet. In each of these workflows we want to send certain fields via the email. Do I need to select each of these fields for each (30!!) of the individual workflows? I cannot see how to copy and paste the relevant fields. I am assigning…
-
Contact us integration ?
I'm running a recruiting campaign and I need to log all of the leads that are going to come in from separate landing pages. Is it possible to have those contacts be uploaded to a spread sheet the moment a person submits an application?