-
How to Link my 2020 Capital Budget to my Capital Budget Form
Hello My organization has finalized our 2020 Capital Ex Budget. Starting in January 2020, I want to create a Capital Exp Form that provides the options that were approved for the 2020 Cap Ex Budget. For example, the form would be set up as follows: 1. Is the capital expenditure request a 2020 approved capital expenditure.…
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
-
Update on Time Options?
Hi - I have been searching through old posts and I see many mentions of a new feature that's hopefully coming soon to be able to track time in a column (24 hour format would be great). Any update as to when this may be available? Thank you!
-
Multiple criteria for approval workflow
I need to create an approval workflow where 2 criteria need to be met but it seems the only option is "or" and not "and" (see screen shot). Is there a way to have an approval sent out only if both criteria are met?
-
Can I have multiple attachment fields in a web form?
I have a new requirement to have more than attachment field in a web form. Example: the form asks for specific budget information in one section requiring upload(s), and then in another section we would like to add an area to add receipt information. It would be OK if they are stored together in the Smartsheet when…
-
manually moved rows bounce back to original location
We have a gremlin! There have been two instances now where we manually move a row, smartsheet appears to be moving it, then it ends up back on the original smartsheet. The activity tracker shows the attempts on both smartsheets. Any idea why?
-
Overwriting lines
We are currently having issues with lines being overwritten when more than one team member is entering information into a sheet at the same time. Anyone else experiencing these issues?
-
Automating RYG balls to change colors
So i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want: If one of the dependencies has a red color ball, I want the parent ball color to be red. If all dependencies have a green ball, I want the ball for the parent to be green If all dependencies have a…
-
Sheet automation with a mix of relative dates and date ranges
Hello, One of our teams is using Smartsheet for team calendars, tracking things like time off, travel, working from home days, etc. Key notification criteria is based on start and/or end dates. Currently, their notification is setup to trigger when the start date is today. This doesn't catch when there is a date range…
-
"Recently Opened" Navigation bar Question
Hello All, I have been a huge fan of the "recently opened" Navigation tab and have about 30 sheets pinned. I do use various sheets at various times, however, and would like to rearrange the order of these sheets as well as be able to bucket them. I understand that this wasn't quite the point and workspaces/sheets were made…