-
Automated Notifications
I have created a SS and linked it to my main sheet. I've also created notifications for this newly created sheet, but I do not receive any of the notifications that I have set up it. The linking part works fine, but how do I get my notifications to come through from the linked sheet? I've also checked my notification…
-
how to automatically add a date when another cell value is added
I am trying to add in a formula to automatically add the date in the "date completed" cell when the "completed initials" drop down value has been added. What is the correct formula to make this work? I want the date to automatically populate when the job has been completed.
-
Smartsheet Releases & Reports of Potential System Issues
Hi Smartsheet Community! Today I was alerted to a couple of issues that I am wondering whether or not they are related to the recent releases. (1) My Intake form that has a contact list value was not working even though it was previously. I went ahead and selected the contacts in my sheet and the values are now visible. So…
-
How can I lock a cell that I pull from another sheet?
How can I lock a cell that I pull from another sheet? In this example will be : {Formula Table Range 9}, {Formula Table Range 11} =IF($[Week-X]1 = {Formula Table Range 9}, {Formula Table Range 10}, IF($[Week-X]1 = {Formula Table Range 11}, {Formula Table Range 12}, IF($[Week-X]1 = {Formula Table Range 13}, {Formula Table…
-
"Iterative" Formulas or Loops
Hello everyone. I am having an issue where I do not see a way to make any of my formulas iterate any specified number of times, let's say similarly to a "for" loop in a programming language. I am curious if there is a solution I am overlooking or if this is not currently doable with Smartsheet. Please see my example below,…
-
3 base files with confidential infos in a combine master file
I have 3 different sheets. Each sheet if filled out by a factory and I would like to summerize the content of this 3 sheets in a master file. The factories are not allowed to see the content of the other sheets (A,B,C, Master) only their own sheet. The master file is shared with other people than the base flles (A;B;C).…
-
How can I keep the colors in the calendar app view from changing when data is changed?
I built a calendar view from a report (no pre-selected colors assigned), which has primary and secondary grouping. The colors assigned were fine, however whenever the in-line data was changed through the detail view that pops up when you click on a calendar bar, all the colors for the entire view would change to other…
-
How can I have the results of two different forms populate to one sheet?
I have a sheet called Event Sheet. There is a lengthy form associated with this sheet that allows submitters to request rooms for a specific date / time, etc. It also allows them to request media, room setup, etc. I duplicated this form and created a 'short form' and took out many of the inputs so folks can just request a…
-
Lines of my Smartsheet are Archiving in error
Good day, I am having an issue where some of my lines on the Smartsheet will automatically move to the Archive sheet without my checking the archive box. We have our sheet set up so that if we check the Archive box it will then go over to our Archive sheet. But, it should not leave our active sheet unless this box is…
-
is there a way to view a sheet in the same window as a "modern" theme form?
I have a form, using the modern theme, that requires the user to enter a unique numerical code associated with a project, as part of the project's approval process. Is there a way for the user to see the sheet (or part of it) that contains the list of these codes, so that they dont have to go searching around the dashboard…