-
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…
-
Can you add ticketing function to a preexisting Smartsheet form?
I made several forms in Smartsheet but want to add a ticketing function to them. How can I do this? Or do I have to re-make them suing a ticketing template? Thanks!
-
Populating dates based on another Smartsheet
Hello, I have a Master Project Smartsheet that I own and my client wants to have edit access to the lines they own. I don't want to provide them edit access to the entire "Master" Smartsheet, but would like to provide them edit access to the deliverables and dates that they own to avoid us having two working documents that…
-
Date-Time vs Date - Strange Behavior?
I noticed that if you neglect the fact that a date-time is not the same as a date, you get unexpected results. If you look at the image you see a date-time and a date column that is set to equal the column to its left. As you can see it does not produce an error, and it populates the date. However, only in certain…