-
Sumif Help please
I want my totaling cell to add quote on the criteria below. I have a drop down list in column 1 , in that list I have (con/fine, con/course, con/xtra, ash/fine, ash/course, ash/xtra. grind/fine, grind/course, grind/xtra........this continues for another dozen or so products. I have m2 rate in column 2, so I enter the data…
-
Resource view for multiple projects in a single sheet
I have couple of 'Resource View' questions... 1. Is it possible at all to use a single sheet to have multiple projects (as multiple parent tasks) and have 'resource view' to show the allocation against the parent tasks rather than multiple sheets? I need to see the break down of resource allocation based on these parent…
-
planned % complete
Hi guys, any advise on how works with % completed vs planned % completed as smartsheets only has column for % completed?, has anyone achieved to make a similar column for planned %?
-
Suggestions for Calendar Syncing
Hello, I recently had an issue with calendar syncing, you can see the thread here: https://community.smartsheet.com/discussion/resyncing-google-calendar As you can see in the response to the thread that a resync option isn't available. I had also had a conversation with Smartsheet support prior to getting a response on the…
-
How can you edit a collborators e-mail address?
I want to edit an e-mail associated with a collaborator because it has changed. There seems to be no way to edit anything in the Sharing area. I know how to edit My Smartsheet Contacts, but that doesn't help. Sometimes the collaborator contact doesn't show up in My Smartsheet Contacts. Even if it does, and I successfully…
-
Notification
Hi all, I need some help... Whilst I am of the understanding that you can set up notifications when a user makes any changes to a sheet, is there any way you can be notified if someone has in fact opened a sheet they have been invited to view? Thanks in advance
-
If value used elsewhere then conditional formatting
On one of my sheets we have a column with order reference numbers with the following format XYZ0123. I have been trying to set up a conditional format to warn me if I am reusing a previous number further down in the same column. So, if I enter ABC0345 and it has already been used in one of the cells further down the same…
-
automation of checkbox or RYG balls (or something)
Good morning! I have 3 sheets that work together to serve various functions, including taking daily attendance. MASTER CAST LIST lists each person's name, SIGN IN SHEET and CONFLICT CALENDAR are driven by forms with contact formatted drop down lists. It's all the same people on each of the 3 sheets and the primary columns…
-
Can a Workspace be Deleted?
Hi, I am new to Smartsheet. Is it possible to delete a Workspace? If deleting a Workspace is possible, can I please get the steps to do this? If it is not possible to delete a Workspace, what practice(s) are users implementing for Workspaces that are no longer in use and that we no longer want to see? Thanks
-
notification
can i set a notification that is driven by a date and a name. ie i have a date column with a date range for my local school term, showing weekdays only. my next column is a recurring set of names, and finally my third column is a column titled 'tasks'. what i want SS to do is to send the person in column 2 a notification…