-
Formula with a # result
Goal: I'm basing this "costing" formula off of a cell that is in % format, the format in the "costing" cell is $. If Percent8 Cell is x THEN this # 0 through 0.43 = 50 0.44 through 0.90 = 75 0.91 through 1.00 = 100 What is wrong with my formula? I keep getting an #unparaseable message =IF(AND(Percent8 >= 0, Percent8 <=…
-
Brand alert/notification emails
Is it possible to brand our alert/notification emails? When I manually send an email from a sheet, it displays nicely, with our logo across the top, and I can choose a vertical format. When I get an alert/notification email, the display looks completely different, and the Smartsheet logo is at the top (instead of our…
-
Formulas not working in some rows
Hi there, I have this formula running in a field called Contract. This sums up all the pricing across this line. =SUM([Facility Rental]373 + [Curtain Fee]373 + [Chair Fee]373 + [Stage Fee]373 + [Porch Fee]373 + [Lot Fee]373 + [Rehearsal Fee]373 + [Cleaning Fee]373). This is working in some of the rows but not in all of…
-
Missing Column Criteria from Report Builder
Hi, I have been working on a report builder for a number of sheets from varying projects to show specific items. Understanding that I need to have consistent column names across all sheets, I have gone through the trouble of formatting them all. My issue now is that when I go to the report builder and I want to add more…
-
Process mapping
Does anyone use a process mapping tool such as Visio or TaskMap that can integrate well with Smartsheet?
-
Calculate Date for Status Change
Does anyone know how to capture or calculate the current date that a status has changed on a task? I'm trying to capture the dates that each task is moved through the status phases of To Do, In Process, Done.
-
Web Form session time
Hello, Is there a save-what-I-have-typed-in function in web form? for example, I didn't finish the web form at once, maybe, I left in the middle of it. When I come back to it, can I still use the same web form, and when I click submit, can this form be submitted successfully? I know this is a strange question, and I…
-
Undo Sort
Hello, Is there any way that an old version of a smartsheet can be accesses? Someone has sorted a smartsheet that was not set up for sorting and it is now unusable. Any way that I can undo the sort? Thanks!
-
Forumal to reset the Check Box
Has anyone used a formula to uncheck a check box? I am trying to set up a formula to check to see what day of the month it is and so far I have most of it working I am just stuck on the check box portion as my conditional formatting looks to see if the Done box is checked as well as it is past the 1st of the month.
-
Clone a widget to another sight?
I've got a nice set of KPI's pulled together on a 'demo' sight that I was reviewing with my team. Now that we're happy with the look and feel, I'd like to publish them to a different sight for a broader audience. I know there's a 'clone' button. I don't see an option to 'clone' a widget to another sight. Is the only option…
