-
Sheet Summary
Hi, When copying a sheet summary to other sheets within the same workspace, it carries the field names but not always the information within the field. For example, after having copied the sheet Summary, the "Completion %" shows =[% Complete]30 + " %" or #UNPARSEABLE, instead of an actual number, ie. 50 %. There's no…
-
IF formula with multiple criteria
I am attempting to write a formula based on 2 separate criteria, though I feel like I need some type of "BUT" statement and could use some help. I want a picklist column to read YES or NO depending on the following: IF Ins Status = Current OR N/A AND Agreement EXE is checked THEN Approved for Work = YES, BUT, IF Agreement…
-
Does the link for a form change if the sheet is moved?
I am an admin working on cleaning up our structure within Smartsheet to utilize workspaces and folders more. Will the link for a form that is shared across many users change if I move the sheet to a workspace?
-
Formula for percentage complete and duration remaining
I am trying to develop a formula to flag tasks that are less than 50% complete but more than 50% of the duration has passed. I'm not sure if my math is correct. But aside from that, can Smartsheet perform functions like the one I am proposing below? Currently, it returns an unparseable error. If I get this formula to work,…
-
Deleted user still able to access Smartsheet
Hi, I'm looking for some help on how to eliminate some risk when team members leave the company. They are deleted as a user and sheets transferred, however these said users after they have been deleted are still able to access into Smartsheet when they log on with a password but not single sign on. Once logged on they…
-
How to view a calendar by column other than the primary
Hello Smartsheet Community, I am trying to find a work around to view a calendar by more than just the info in the primary column. I currently have a sheet that contains all of our workshop orders for a particular product range. It contains the customer name, product type, dispatch date, ect. We look at this sheet in…
-
Count only if Parent
I have a [RowID] column that is populated by this formula =IF(ANCESTORS@row = 0, COUNT($ANCESTORS$1:$ANCESTORS@row, "")) It returns sequential numbers but, I need it to only count if Ancestor = 0 Secondly, I need the result fill format to look like this 0000 (like an auto number) 0001 0002... 0100 0101 0102.. 1000
-
Nested If Formula
Hello, I am trying to create a nested IF formula based on the criteria below. Below is also a screenshot of what I am trying to do: =IF([% Complete]1=0,"Not started" =IF([% Complete]1>=0 and <=1, "On track" <code class="CodeInline">=IF([%Complete)]1=1,"Completed" =IF([%Complete)]1<=1 and Due Date is past,…
-
[UPDATED] Community email notifications and saving important posts
Unsubscribe or Manage Community Email Notifications In the upper-right corner of the Community, click your Profile > Account & Privacy Settings Choose Notification Preferences from the options on the right. You can subscribe to any of your Followed Topics to receive notifications for every new post in the online Community!…
-
Archived Community Post: Why am I asked to log in to Smartsheet to use Community?
Hello, I am wondering why I am asked to log into Smartsheet if I have clicked on Help from my Smartsheet window? Shouldn't Smartsheet know I am logged in since I accessed it from my already logged into Smartsheet? Thanks!
