-
Smartsheet Customer Story Program
Hello Community! I manage the Customer Story Program here at Smartsheet, and currently we are looking for the next great story to share. There are many ways to share your story, and just as many benefits to participation. Sharing your story can document your success, grow your brand and advance your career. Learn more at…
-
Using formula - Pick first day of the week
For example, today is 11/15, and first of the day (Monday) of this week is 11/13. How can I pick up 11/13? Thanks for your advice!
-
MOVE FORMULA TO ANOTHER SHEET..... This could be the answer !
Hi All, As I have brought up in the past, moving formulas to another sheet would be extremely powerful. The sheets I have designed are used for different departments....Sales, Production, Accounts/Admin. By duplicating each (4) sheet, all irrelevant data in that department is hidden i.e. those rows are there but hidden…
-
Summary Status on Parent Row
Hi - My apologies if the answer is somewhere in the community but I can't seem to find it. I have a project sheet and in it, I have a (RYG) status column. I would like a status symbol to appear in the parent rows. How do I achieve this? I've attached a small screen capture to illustrate where I would like the status ball…
-
Subtotals without parent/children rows?
Hello, I'm working on a sheet where rows are continuously inserted using a web form so I can't use parent/child functionality. These rows contain hours spent on clients and sub-clients. I have two summary rows at the top of the sheet and I'd like the hours column on those two rows to have the total hours for clients (row…
-
DataMesh not finding cell links
I am having issues with DataMesh, as it is unable to look up the values between the sheets. I checked some of them manually, and the numbers exist on the target sheet. I also tried to export into Excel and test this formula. Excel required a re-format of the numbers (text to number format) before it was able to…
-
Setting up notifications and alerts
I am going to have a sheet made for every lot that we land survey on which adds up to a lot. Each sheet I have 13 rows of tasks and 13 rows of columns, 12 of them being contacts and one of them being status of the task. I am trying to set up the notification or alert to contact those in the contact columns when the status…
-
update request and approval request
Hi there, 1st: Is it possible to set a reminder if someone didn't update after he got an update request? 2nd: Is it possible to set a cell value with the date when a approval request is replied. Many Thanks Peter
-
Task Duration - Partial day at beginning of period, not the end
Hi, I notice when you add a half day duration to a task, it places the half day at the end of the period, for example a start date of 13/11/17 (Monday) with a duration of 2.5 days will result in the half day being on the Wednesday. Is it possible to make the half day on the Monday and the full day on the Wednesday? I'm…
-
notification for part of group
Hi, I have a smartsheet and I heard that I can set up notification rules and applied for all shared users. E.g. My sheet is shared with 20 people. There is a column in Smartsheet, "meeting date". I just want notification is triggered as meeting date is changed to any value. However, if I only want notification only…