-
Content from Engage 2019 Keynote speech
I am working on a presentation for our exec team about my experience out at Engage 2019. Does anyone remember the name of the company that spoke during the keynote speech about how they used Smartsheet to get resources organized & on the ground faster during Hurricane Dorian?
-
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…
-
I Need assistance with Formulas in Smart Sheets.
Hello, i am having difficulty with formulas in SmartSheets, Index, Match, and IF Statements. If anyone is an expert, I can get the formula to work in Excel but not in SmartSheets. I have used the help desk, all the formulas they have tried have not worked, I found 1 expert in the Pro Desk who could help the other could…
-
Unparseable Error
When I leave my sheet, a column becomes #unparseable, however it works when I log back into the sheet. Any ideas as to why?
-
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;…
-
Return 1st column value if 2nd and 3rd column is blank
Hello, I am trying to come up with a solution for my smartsheet involving 4 columns (4th being the result column). I wanted to return the value from the 1st column whenever 2nd and 3rd column are blank, if not return the value from either 2nd or 3rd column. These columns contains dates by the way. Sent (1st) ; Won (2nd) ;…
-
Need help with "IF" formula
I am unable to get the formula right for the following scenario: Column 1: Yes / No Column 2: Yes / No If Column 1 and/or Column 2 is blank, then "Not Completed" If Column 1 and Column 2 is Yes, then "Completed" If Column 1 is Yes, Column 2 is No, then "In Progress" If Column 1 is No, Column 2 is Yes, then "KIV"…
-
Master Sheet with Subprojects Inside
Hi! I am trying to create a Master Project sheet that would include subprojects inside of the same sheet. Basically so I can track the dates and overlapping of tasks in the subprojects. Is this something that Smartsheets can do? I know I can do it in MS Project and just add each subproject as it's own task in a master…
-
resource time calculations
Hello, Is there an easy way to sum the time tasked to specific resources. I want to populate an estimate based on my schedule I created but I don't see a way to easily determine how much time each resource has been allocated. I can export to excel and manipulate columns, filters etc. but it seems that there should be some…
-
Cell Reference
Ok, I tend to think I am someone decent in Smartsheet, but I am STRUGGLING with something so simple and would love some help... Background - I have a project team and we use smartsheet forms for time tracking. Every month we archive the previous month's data on a separate sheet. However, to calculate metrics, I do a SUMIF…
