Update Emails Request Not Sending
Via Automations and directly when I send Update requests, none of my recipients are receiving the emails. I have tried multiple destination addresses, I have deleted all pending requests. I have checked that after I send them that they are pending. I have waited hours to make sure they don't come through. How can I…
Importing Dates from Excel into Smartsheet
I'm creating a new Smartsheet Grid by importing from an Excel. 3 of the columns in my Excel are formatted as Dates in Excel. However, when the Grid gets created, these 3 columns show up as "Text/Number" fields. Is there any way to get around this?
why are my emails not being sent in an automation?
I am putting automations in a sheet, and the email piece of a couple of them are not sending. I have automations in this sheet and others that do send emails. And the other items in the automations are running, just not the emails. What could be going on?
Can you Log a Cell In time?
Within my project sheet I have formulas set up to show me the present of Target duration vs actual completion date. The parentage in cell will change as we close out projects. Is there a way to track/Log this cell as it changes so that I can create a line graph to see our patterns over time?
Count Children Rows w/ Specific Statuses
Hello, I have a Status column that has the following drop-down items - To Do, In Progress, Done, and Future Work Cycle Task. I want to sum the # of child rows with the status of To Do or In Progress. I tried =COUNTIFS(CHILDREN(), "To Do", CHILDREN(), "In Progress") and it doesn't work; however, when tried just…
Fiscal Year Starts in February sometimes end of January
Our fiscal years (FY), quarters (Q) and work weeks (WW) are giving me heartburn. I realize I need to create a table in order to capture each fiscal year. However, when putting in the formulas so far I am seeing issues with my Work Weeks and Fiscal Year columns. Part one (1) of my heartburn. For example, my work week is…
Workflow - COPY Rows but also ability to have updates to select COPY Cells going forward
We are still early in our Smartsheet project evolution so we have not purchased Control Center for project creation automation. For now, we are manually creating a PROJECT FOLDER with its assets included every time we have a new project. I'm looking to set-up a workflow to COPY over a ROW of data onto another SHEET…
Importing from Excel works one way, but not another?
Hi there, I am trying to create a new sheet from Excel data. If I create the sheet and then go into the sheet and click File>Import>Import from Microsoft Excel, I can pull the data in, but when I leave the sheet, everything is gone. When I import the data, I follow all the usual import steps, but the Save option is grayed…
Smartsheet to allow for multiple updates to a line
Hi there, I am looking for a way to be able to have our employees update a single line each time they reach out to a person with the date they reached out and any notes. They may reach out multiple times in a months time, just not for sure how many time. For example: We have a ton of clients. Hospital X: Reached out on…
Replying to Comment via email
When I send a comment using @ functionality from a Sheet, I would like reply comments to come into the Sheet. In other words, the recipient should be able to simply use "reply" via Outlook to send a reply, rather than needing to log into the Sheet to reply. I have used SS for at least 3 years, and that was always standard…