-
When configuring an email like an update request, what are the domain options?
e.g., would it come from carolyn@smartsheet or could it come from carolyn@uva?
-
How do you change the color of non working days?
I currently have a light color for non working days which is similar to my weekends color. I am trying to change the color for non working days. Thanks
-
Automatic project creation and reporting
Dear community, I have a scenario which gives me quite a headache. I would like to create a form which will be populated by the project requesters for creating projects in Smartsheet based on a set template. The form will have multiple fields. Once the form is submitted it will have to trigger an alert/reminder for…
-
Can I download Contact Information From Smartsheets?
Hello, I have some data saved as contacts in smartsheet. I would like to use this data off smartsheet, however, when I export this data I only get the name of the contact but not the underlying email/phone number. Is there a way to pull this data from Smartsheets? If not, what workaround can I use to retrieve the stored…
-
How can i make it so Viewers of a sheet or a report can also comment?
I really need to be able to have viewers access a "view only" report that is published and be able to provide comments in the report. How do we get this functionality?
-
Calculating NETWORKDAYS for a 6 day week
Hello, I need a formula to calculate days gained/lost on a project which has 6 working days per week. Is there a way to calculate NETWORKDAYS for a 6 day week in Smartsheet, similar to NETWORKDAYS.INTL function in Excel? Or is there an alternative way to calculate days gained/lost? Thank you.
-
Using IF and OR to Assign a Contact
I am currently using the following: =IF(Line@row = "Apples", {Contact 1}), IF(Line@row = "Oranges", {Contact 2}), IF(Line@row = "Pineapples", {Contact 3}), IF(OR(Line@row = "Red Grapes", Line@row = "Blue Grapes", Line@row = "Purple Grapes", Line@row = "Green Grapes"), {Contact 4}), IF(OR(Line@row = "Pears", Line@row =…
-
Summary Report
Hi, In a typical sheet of say 10 tasks i have, where applicable, resource names assigned per row. I would like to add up all the named resources on a sheet and display them in one cell in my summary report. Is this possible?
-
Report widgets on dashboards: Column titles are misaligned from columns.
Bit of a weird issue that I've never seen before. This is a report on a dash widget of a yearly planner, so 380 or so columns. The column title is starting to become misaligned from the actually columns. It displays perfectly on the actual report, but does this on the widget view. As you scroll over it drifts further and…
-
Count the number of instances per week?
Hi- I have a formula that counts the number of times "User Received"is in the Status column for the month of February. =COUNTIFS(Status:Status, "USER RECEIVED", [Need By Date]:[Need By Date], IFERROR(MONTH(@cell), 0) = 2) two questions: how can I make this formula count the Feb instances as separate instances if for…
