-
Resource time allocation
Hi, I am new to Smartsheet (have used MS Project) I am looking how the following would be best to implement. An overall task may take say 15d's out of that 15d's an assigned resource may only be required for 1 day out of those 15d's. Thanks for your help in advance. Cap
-
Eloqua & Smartsheet Dashboard
Hi there, My company is new to both the Eloqua and Smartsheet community. I am looking for an easy integration between the two in order to have Eloqua metrics ported over to smartsheet for an easy and clean exporting process. Any suggestions on how this would work or if it is doable? Thanks so much!
-
Need help with getting parent and sub parent data
I have a format that looks like this Project Name PreCon Name Name Construction Name I am looking for a formula that adds text to a column for each name structured as "Project Name - PreCon" or "Project Name - Construction" I can get it to work using explicit references =PARENT([Task Name]13) + " " + PARENT([Task Name]14)…
-
Web form phone contact filling by customer missing number can it set formatting?
Web form phone contact filling by customer missing number can it set formatting? Due to our client typing through the form by themselves some time we can't control what they type. At this stage, for my case I just wonder is there a way to set the format condition to make the fill in data from this example Phone…
-
Turn hours (hh:mm) to numeric value (00.00)
Is there a formula to make a column with duration values like 1:30, 2:45, 3:15, etc etc (only ending in either :00, :15, :30, and :45) to 1.5, 2.75, 3.25 hours (again, only ending in .00, .25, .50, and .75, respectively)??? I am VERY new to SmartSheet so, if you could actually explain how to do stuff that would be awesome.…
-
"Pretty" PDF export -- Google merge, something else?
Hi all, We’re hoping to be able to export a fairly complicated styled PDF from Smartsheets. Imagine a sheet of movie reviews, where Column A is movie title, B is review, C is reviewer and D is date. Each movie can have multiple rows depending on how many reviews it’s received. We’d like to get a PDF that would look a…
-
How do you write formula so that IF checkbox is checked, the percent complete is 100%
I am trying to make it easier by having a checkbox = 100% rather than manually writing 100% to fill out my gantts I have failed at this. The name of my checkbox column is "Done" So what should my formula look like? All of these are failing '=IF([Done15 = 1], 100%) =IF([Check Column] = 1, 100%) Help?!
-
Duration Column Doesn't SUM up Correctly
Hello, I am using smartsheet for my master project plan and I repeatedly run into one issue, my project Duration count roll up is inaccurate. I have attached a screenshot to provide a better understanding of the issue.
-
gmail group mail or distribution list doesn't work in assigned to.
Hi Smartsheet Team, We have group mail via gmail in our company. Im using it to Assigned To contact list to notify them all for any changes. But unfortunately it doesn't work. What could be the problem. Smartsheet Group does not appear in Assigned to as well.
-
in cell comment and comment grouping
hi, in cell commenting would really enhance this product and really is a must have when managing large sheets. ultimately the row comment button could be the aggregation of all of the rows specific cell comments. if you take this step and i hope you do, you might want to consider multi cell comment grouping. so,…
