-
Working and NonWorking Days by Resource
I want to add working/non working days and times to specific resources in one place and when I add that person to a particular project, those working/non working days will automatically follow. I also want the ability for an individual to indicate when they are and are not working for themselves, so that when they are…
-
Can a Viewer Respond to an Update Request?
Can''t find an answer to this. I need people to be able to respond to update requests and enter info there, BUT NOT enter anything at the sheet level. Can a viewer do this? Thank you!!
-
Filter Organization
Does SmartSheet have any way to organize filters? I have a large sheet where everything falls into one of five categories. There are then ten sub-categories for each main category. I would like to create filters for these 50 combinations, but I don't want to have my team users scroll thru 60+ filters. Ideally I would put…
-
Dashboard Publishing
I have a dashboard that I have added the link to other dashboards. I have published all the dashboards. When I share the link with those without smartsheet access they are only able to view the main dashboard. When they try to access any of the other dashboards they are required to enter a smart sheet login. Any advice?
-
SUMIF with multiple columns
This should be simple but I appear to be going wrong somewhere. I have the following working for two columns =SUMIF([Loan Manager]:[Loan Manager], "GE", [Loan Amount]:[Loan Amount]) When I try to add another look up column it doesn't work, as below =SUMIF([Loan Manager]:[Loan Manager], "GE" , [Loan Status]:[Loan Status],…
-
How to loop through workflow
I'm having a problem creating an approval flow. When the approver denies the flow, it automatically sends an email to the one who requested the approval asking him to clear the wrong field. I need that after the field is arranged the system understands that it should again send an email for approval. I do not want to…
-
Resource allocation with part time workers
Hello all, I saw that there was a question on here way back in 2015 about whether you could assign different users different availabilities and have that show up in the resource allocation function. At the time Smartsheet folks said they were "working on it." I'm wondering if there has been any progress on that over the…
-
Send as Attachment Feature
Is there a way to clean out the list of who was sent this way? I only want to see what items I have as recurring and not see ones I did as a one off.
-
Help on a formula
Hi there, I try to convert hours to duration, on a basis : 7 hours = 1 day. I made a formula that has been working so far. But my boss asked me to add a minute setting. So that's my formula : = IF(AND(Heures@row = "0,5"); 0,05; IF(AND(Heures@row = "1"); 0,1; IF(AND(Heures@row = "1,5"); 0,2; IF(AND(Heures@row = "2"); 0,3;…
-
Cell is considered "changed" when it goes from Blank to Filled - Why
I have a sheet set up that populates rows with information filled out from a Smartsheet form. Rows are only added by filling out the form. When a row is added (i.e. form is submitted) a notification is sent out to a mailing list of individuals. This all works fine. I have a separate workflow notification in the same sheet…
