-
Need a formula to add a today's date in a date column
Hello Everyone, I am looking for a formula that will add today's date if certain criteria has been met. If "Approved" or "Denied" has been entered into the Status column I would like today's date to automatically be entered in the date column. Thanks in advance. Stephanie
-
Reports
I have several reports built that pull from several sheets. I have rules created for a couple columns so that only specific lines are included in the reports. They all have 50 lines even if there are only 25 lines with information. The rest of the lines are blank and not able to be edited. I have other reports that are…
-
Is there a Japanese or Japanese company here?
Hello there, This is Kikuchi, working at a Japanese company in Tokyo, Japan. We are going to start smartsheet in our company and wondering if there are any Japanese users here? so that we can exchange the questions or experiences. Please let me know if you are a Japanese!! Thank you very much for your attention. Best…
-
Requirement Traceability
Hi there - We are struggling with some inadequacies with our internal requirements management system and are looking for a workaround or way to leverage Smartsheet for this purpose. Main goals being requirement traceability and bulk uploads. Has anyone leveraged Smartsheet for requirement management and repository…
-
Request - Find and Replace option in project sheets
While using my project sheet, I will perform a Save as New to copy my format; however I will need to do bulk changes. It would be such a time saver if I could perform a Find/Replace (all).
-
Comments input area is 'hidden'
When I open the comments dialog, the area to input text is hidden. It has been this way for a few days now. What can I do to fix this?
-
Trying to have autonumber show in a webform.
Hi all, I am creating a survey in SS, with a form for collecting answers. I'd like to use a auto number column as a way to create a unique ID for each row. However, I'd like that unique autonumber to show up in the form. This is so users when filling out the form, can see the unique ID associated with their submission. Any…
-
Publishing read access sheet/report with common password
Hello all, We are facing a situation where we want to publish a report in reading mode to a group a people. We do not want the information to be public on the internet so the basic Publish is not an option and since the people only access to this information couple time a year, creating a managing a Smartsheet account for…
-
One Task with multiple Predecessors
Hello, New to SmartSheet. Question is, I am working backwards, and i have one Task (Task 3) with four Predecessors. These four Predecessors end up having different Start dates. Task 3 ends up having an End date of the Predecessor with the shortest Duration. Shouldn't Task 3 have an End date of the Predecessor with the…
-
Needing an "If, Than" formula for multiple variables
I am pulling together stats for a project using the JIRA connector and I need to be able to SUM all "Open" issues + "Reviewed" issues into one cell. I have the beginning of the statement and it works just fine, but whatever I tried to add the last part, "Reviewed" I get an unparseable error. Here is what I have:…
