Peggy
Peggy
Discussions
- My formula is giving an error. it works fine until I try to add the month. The month calculated field is a number/text field. What else could be the issue? =AVG(COLLECT({DYS to Completion}, {Applicati…
- here is my formula, but I keep getting an error. I can get the average, but now I want to know the average within Quarter 1 =AVG(COLLECT({DYS to Completion}, {Qtr}, "1"))
- Hi, We have some Smartsheet that we need to keep for historical reasons. And we backed up the sheets. How can we prevent the formulas from triggering to avoid recalculations in the historical archived…
- Is there a plan for smartsheet to generate the documents in word or convert the pdf to word without using adobe or another tool? We have documents that have some data from the smartsheet and then it i…
- When using document builder, I am pulling a field that is a contact list column type. when the program to build the document runs, it shows the email address instead of the contacts name. How can I ge…
- Hi, I have two sheets with column descriptions. I have shared these sheets via a report for users to make their updates. From the Report they do not see the column descriptions. Is there a way they ca…
- Hi, We created a form to take in change request. The sheet has a column 'Interested Party" and this is a contact list. When i am in the sheet, i can start typing a name and the contact list based onth…
- Hi, I have a conditional format setup to look at a specific product line and GEO when it does not contain specific geo's then apply a grey format to 2 fields, so that people know that nothing is requi…
- Hi, I have a master smartsheet with client name, a date and the clients product lines, on a row. The product line column is a multiple select, restricted to a specific list of values. I have second sm…
- Is there a way to export the list of collaborators from the sheet sharing view of a Smartsheet?
