-
cannot delete ref links from vlookup
Hi I tested vlookup function and I created a new sheet .I deleted this new sheet but now in my master sheet it's still outbound to ref unknown sheet. I cannot delete that link...
-
IF AND function
First time here and new to Smartsheet. In a cell I have a number. Say 400 In another cell I have a specific date. Say January 1, 2020 What I want to do as a task start date in another cell is: If the number in the cell falls within a number range on another sheet I want the task start date to be, specific date – 18 months…
-
2 week task for 2 hours each day
Is it possible to have a task with a duration of say 2 weeks, but only allocate a fraction of the day’s hours to the assigned resource? For example, John Smith is assigned Qlik development that will last for 2 weeks, but will only be developing for 2 hours/day. I know it’s possible to change the default length of a day…
-
Internet explorer stops working while trying to open an existing sheet
I have a new user that is encountering an issue when she tries to open an existing sheet. She retrieves an error that Internet Explorer has stopped working. she has to close and restart. the sheet is approximately 600 lines and looks like a standard project sheet. She is able to open other sheets without an issue but it is…
-
Secure Login & Password
Hi, We want to secure User id and Password for my account by Generating codes to Mobile or the email id. We have 3 license and the users using out of office to access the data, I want to make sure the login to new system will create a code like that Gmail generates the 2 step verification code. Please suggest. Regards,…
-
Resource Management
Hey Guys, unsure if this is possible but lets see. I am going to be using card view as a kanban style work stream for my team, each card will have an estimated effort as to how long the job will take and an actual field for the actual time. each of my staff i could say has 5 hours a day free. what i am trying to achieve is…
-
Possible gannt chart features
I've noticed that in order to move through the timeline of the gannt chart you have to use the lower scroll bar. It would be nice if you could hold left, right or middle click within the gannt chart and drag left or right. Easier and faster than having to use the lower scroll bar. Whenever switching to the gannt the…
-
How to change row formatting based on a single cell?
I am trying to create a list of design standards and have a drop down list in a column that associates each row to a different project type: Affordable, Market, Selling. I'd like to be able to have the first row be a control that sets criteria for the rest of the sheet or a specific column. Thus if I select "affordable" in…
-
Community Platform
Did Smartsheet develop the software running on the "Community" or did you purchase collaborative software? If you purchased the software, can you tell what program is being used. I find the Community and how it functions to be very good.
-
Report sharing access
Hi, There are 7 individual sheets with information on various industries in each of the sheets. I have created a report to pull information on a particular industry and have shared that with a collaborator. However, as he does not have access to the individual sheets, he's isn't able to see the information on the report. I…
