-
Copy Row automation brings original sheet 'Created date' instead of showing date it was moved
Please help, I have a helper sheet that I am using to capture time stamps of when a row goes to different statuses (ex: capture time stamp when request status changes from: In Review, Pending Response, and Completed). To do that I set up a copy row automation that triggers when those statuses change. Then it copies the row…
-
Ability to sort column property values in ascending and descending order
Often we will need to update/edit a column properties Values and when the new values are added, they are not always sorted in any particular order. Currently to workaround this, I open an Excel sheet → put the values in a column → sort the column. It would be a heck of a lot cooler if I could do that in when editing the…
-
Set Up Auto Notification
Is there a way to set up an automatic notification to send to an email address in a cell? When ive tried to set this up ive selected send to Contact but it only recognises the Created By field as a contact list.
-
Linked cell not working
I have linked my plan cell with another cell from another plan (it was task status btw), so it will serve as reference for my plan when my dependency task is complete, I can proceed with my tasks, but the content of this cell is not updating (the other links I did worked). What could be happening? thanks.
-
Why can't I access the workflow automations on a sheet that was shared to me?
The sheet owner already made me an admin yet I still couldn't open the workflow automations tab (I can access the forms, edit the columns, rows, cells, and etc.) I have good network connection and I already tried refreshing the tab several times. They even removed me then added me again multiple time but the same message…
-
Copying rows to new sheets based on multiple selections in one column
Hello, new to Smartsheet so might not use the correct language, but hopefully someone understands what I need! In my company we host CPD sessions where suppliers will come in for an hour over lunch and teach us something new. We need to keep a record of these sessions and who attended them. I have set up a sheet where I…
-
Smartsheets tab freezing
Hello, my users have been having an ongoing issue for the last couple of weeks where the tab for smartsheets will freeze when left alone for a few minutes. It happens when in a sheet or not in a sheet. This can be consistently replicated when the computers lock screen is triggered. I have contacted support and they…
-
Does anyone have a support phone number for Smartsheet
I don't seem to be able to find one anywhere. I'm handling coordination for multiple teams on a project and I have multiple resources having trouble receiving the account creation e-mail confirmation.
-
Cross-sheet COUNTIFS Formula Not Working as Intended
I am using a helper sheet to calculate projects that are Past Due, Due this Week, and Pending Review per Requestor Email (this email comes via a form). The formula I am having issues with is the the one I am trying to create to count the number of projects that are due this week. I need to formula to count the rows that…
-
Can I combine multiple rows into one row on a Gantt Chart?
Dear all, I want to aggregate multiple project schedules into a master schedule. When copying the milestones from various projects into a single sheet, my overall Gantt Chart displays an event as a row, and each project occupies many rows. Is there any method to combine multiple rows into one row and use one row to present…