-
Removing a licensed user
We have 3 licensed users. One of the users left the company and is no more accessible. We would like to move his license to another user, and move the ownership of all his sheets to another user too. I am one of the licensed users. What should I do first? move his license then move the ownership of his sheets? or…
-
Alerts & Action notification
Hello, I am trying to modify the Alert&Action notification which I receive when someone updates the sheet via form. This sheet has around 50 columns which need to be updated, and form updates them regularly. However, I would like to receive a short summary of the 15 fields of most interest but it seems that notification…
-
How Do I tell a cell that if the cell contains a date then subtract from another date, If the cell d
I'm stumped. I've written a formula that says, if my finish date is blank, then take my start date and subtract it from today's date to get the # of days open: =IF([Finish Date]2 = 0, TODAY() - [Start Date]2) Works great! But in the same formula, I'm trying to get it to say, but if the finish date is NOT blank then take…
-
More #UNPARSEABLE problems
Hi all I have no idea why this is not working. Here is the formula that I am trying: =if([Opportunity Stage]1="Lead - Qualified",5%,if([Opportunity Stage]1="Scoping Requirements",10%,if([Opportunity Stage]1="Proposal/Quote/RFP Presented",25%,if([Opportunity Stage]1="Contract - Legal Review",40%,if([Opportunity…
-
Sheet and Dashbaord Hand In hand
Hi Guys We have a sheet with a dashboard that we would like to use as a template The sheet can be saved as a template but what about the dashboard? We do not want to have to keep on reentering the widgets.... Thanks
-
Auto Sort Based on radio buttons
Hi is it possible to move rows and children within the rows to a different sub-category. e.g. we have a purchasing smartsheet which has 3 status icons which are either blank or green for processed for: 1. Ordered 2. Paid 3. Delivered Based on the status of each column i would like to sort the sheet into three categories,…
-
Filters
Hello, is it possible to create one filter that includes both "at least one condition" and "all conditions" statements in it?
-
how to collate selected rows into a word processing document
Question for the community: I world like to know how I can create a multi- paragraph document by selecting rows with text in a cell. For example: Lets say I typedthe following words into the individual row: Row one: "Black" Row two: "Friendly" Row three: "Dog" So by selecting Row one and row three I wish to generate a…
-
Sudden issues with spell check and text display!
Hello. I have 2 related issues that happened simultaneously and suddenly (1 week ago): (1) although in my personal settings I have English (United States) as regional preference, all correct English words are now underlined in red! (2) in the text/numbers boxes I use to write paragraphs without any problem. Now the…
-
Formula
If column 1 has the word "yes" is there a formula that will place a value of "482000" in column 2? Thanks in advance