-
How to send all attachment files via an email
Some managers don't want to learn a new tool or even follow a link. I'd like to schedule a weekly status report that just sends all attachments (only the latest version of each attachment) to email recipients.
-
Running Multiple Projects on SS
Hey SS Community, I am involved with a company that currently has no central data base overviewing all projects. I want to put a system in place where the PMs can manage their own projects. Also a system where the sales, quoting and other teams can oversee how the projects unfold throughout the project life cycle. I…
-
Downloading multiple files shows wrong file timestamp (7 hours in the future)
Downloading a single attachment from Smartsheet shows the correct file timestamp. But, downloading multiple files shows the File Modified date of 7 hours in the FUTURE. Another time, it was 5 hours in the future. The attachments were PDF's. This is on a Win7 environment. The data itself looks fine (inside the documents).…
-
IT Employee Change Documentation
Good morning everyone, I'm exploring new options to replace out existing, out-dated InfoPath form for employee IT changes in our organization. Right now we get an XML file sent to our helpdesk, financial staff, and office services, so we'd like to be to emulate that functionality, just with a better output file that our…
-
Date Driven row roll off
We keep a list of Completed tasks. Based on the date in the Work_Ended column, I would like to autmomatically move rows > 90 days old onto another sheet, which we'll call Completed Archive. Is there any way to automate this process? Thank you!
-
Average Children Rows with RYG
Hi all. I'm attempting to calculate an average for RYG balls in the parent row. I have gotten to the point of calculating all of my colors, but I'm not sure how to get the average. Here is my calculation thus far: =AVG(COUNTIF(CHILDREN(), "Green") + COUNTIF(CHILDREN(), "Yellow") * 2 + COUNTIF(CHILDREN(), "Red") * 3) This…
-
Error in creating new Smartsheet from Google Drive
Anyone see this or know how to get around this? I could not find anything related to this problem. I have successfully installed the Smartsheet app to Chrome from the Chrome Web Store. I do New->More->Smartsheet. I get past the "Your domain administrator has approved access to Smartsheet" . Then, I see the error message,…
-
Enhancement Request: Batch Updating in App
Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a "batch update" button to update all of the selected rows at once. Currently, user has to select the column to change, then update a particular field, then repeat if multiple fields…
-
i am trying to set up an It Service Request Tracker - Need workflow approval
Ii am trying to set up an It Service Request Tracker that can incorporate the request being sent to specififc individuals for approval. In other words before a lower level user can submit a request, Mgmt needs to review and approve it. Can that be done?
-
Formulas
What is the formula to add 90 days to a range of dates that yields MM/DD/YY as the result in corresponding cells?