-
Date Formula dependent on text
Hi All, I am looking for a formula that can ideftify text in a column and convert it to dates. More specifically I need it to pick up a cell says "X" convert to today's date +30 days, or if it says "Y" convert to today's date +30? I have found a formula that works in identifying only one set of text: =IF([Project Name]34 =…
-
avoid the shared person delete my row
hi, i see some potential of lose of my data if shared to others. for example, my project schedule shared to partnes and they have to update the status, since they are editor and they can delete my row accidently, how could i avoid from this issue to be repeated?
-
Request - Allow Webform to update a specific row number
Hi, I would like to request the ability to enter a row number on a webform. And when the form is returned or submitted by the user. The information on the form is automatically filled into the specified row. I know contact names are entered as text and cannot be linked with the sheet, but maybe a row id is easier to…
-
Repetitive Task List Instantiation - Editing Multiple Tasks From a Master List
A common experience we encounter is when we have long, identical lists of tasks (7 or more), indented under many parent titles, that need editing, as shown below: PARENT ONE * Task ONE * Task TWO * Task THREE. etc. * PARENT TWO * Task ONE * Task TWO * Task THREE. etc. We have many PARENTS with identical lists of tasks that…
-
Compare text in two different columns
I have a large SS that includes two rows of columns...one is the listing of the latest print revision, and I want to compare it to another column reporting which revision the part was actually built to. Both of these columns are populated with a letter (NC, A, B....AZ). My goal is a Conditional format color if the two…
-
Using SmartSheets for small team Project Management - Looking for advice
We are starting to utilize SmartSheets for a small team, light weight Project Mangement solution. It meets our core needs well and I've read up enough to understand some of the basic strategies around setting up a framework in Smartsheets. Where we are struggling now is lower level tracking and collabortion. When doing…
-
Smartsheet Development progress update?
Hi Travis and colleagues, great comunity forum, very impressed! Can we have an update on when we will see hours and minutes added to project plans, I seem to recall this was planned for the Spring this year? Also Gantt on Reports? We have clients waiting for these features. Thanks RichardR
-
I cannot manually re-open manually collapsed columns.
I have collapsed a few columns manually by dragging its header row borders but are now unable to open them back up. Even if I use my browser zoom button to precisely select the border the double arrow cursor will only select either column to the left or right of all the manually collapsed columns. I can verify the columns…
-
Display jobs for the week and who worked on it?
I want to create a sheet that can show the jobs for each week and who worked on it (multiple people can work on it, due to different departments).
-
Hierarchy Management/Usage – Toolbar Button Request
I have a couple of sheets that use hierarchy structure, Multi-level in some cases. To collapse and expand these is a manual process only, however one of my databases in particular I want collapsed as the default. The issue comes when I filter on the required column it is great as you can have it find it and show the…
