Date update by a day but only when a box is ticked
Hi all I have a sheet which has a deadline on it. This deadline may be extended for a variety of reasons (unable to get parts, Waiting for a return email etc) Is there a way to have a check box that, when ticked, It'll add a day to the deadline automatically as it passes. At first, I thought this would be possible via…
Possible for submitter of a form to access Report of only what they submitted?
Hi all, Newer user of Smartsheet and first post here, hoping for some guidance. My overall goal is to create a form that contains a link to a read-only page of all the submitter's requests. I was told I could publish a link to the grid sheet itself and attach the link to the form, however the obvious issue is that it…
Can you change "who" automatic alerts come from?
Morning team, wanted to see if this system wide update is now able to be used as an option? I have the following link from a previous question asked about two years ago on this matter if it helps. Thanks in advance. https://community.smartsheet.com/discussion/68662/can-you-change-who-automatic-alerts-come-from
Nested If(IsBlank or If(IsDate Formula
I am trying to write a formula that returns a date value in the "Actual Date" column, based on the following scenarios... if there is a date in the "Revised Date" column, then return that date in the "Actual Date" column If the "Revised Date" column is blank, and there is a date in the "Forecasted Date" column, then return…
Can not access child rows.
One user in our group can not access the child rows. What might be the problem?
Automating date columns
Hi, I've been digging in the forum for a while for this, apologies if I've missed it. I need to record a start & completion date for tasks and subtasks, in order to generate a duration. I've set up the columns as date only, and enabled dependencies in project settings. When I go to automate the start to record based on my…
Dashboard widget that allows text to be copied.
Hello, We are building some documentation using the Dashboard. I would like to know if there is a way to make it so we can highlight/select text. We are providing long codes, syntaxes, and formulas that the consumer can use. Currently, consumers can only view and not highlight the text.
Dynamic View error when adding group members
Hi I am getting the error below when adding group members. I created another group with members that have the same domain and that I did not add to my account.
Dashboard - Roll Forward
Hey there! I have a dashboard that monitors the status of tasks for Financial Quarterly reporting. To start a new Quarter, I have to manually change the reference sheet from Q1 to Q2 for all the formulas in the sheet as I have to set up a new plan to reference. Is there an easier way of doing this? Would it be just to use…
Link to a sheet provided by another company
I am working with a vendor who also uses Smartsheet. They have provided a URL with their main grid/sheet. I would rather not have to cut and paste it into my own sheet, to capture updates. Is there a way I can reference their URL from within mine for join collects or other formulae? Thanks, Tim