-
And If formulas with date ranges
Hello, I am reaching out to the community for assistance. I am trying to do a date range formula. This following works: =IF(ISBLANK([74. Discharge date]@row), "No Discharge", IF([CRM 30 Day Done]@row = 1, "OK", IF([74. Discharge date]@row > TODAY(+15), "", IF([74. Discharge date]@row < TODAY(+31), "Past Due")))) This is…
-
Forms - Heading/Description
Is there a way to apply formatting to a Heading / Description field in a form? In the Description area, it looks like you can apply formatting (Bold, Underline, font color, backgroung, etc...) However, when I change these values, I don't see where this is reflected on any of the fields. As you can see in the screen shot…
-
Can primary column be auto generated?
Any ideas on how to populate primary column with sytem generated numbers?
-
Pre-populate a form
I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change control log.
-
End User - Features locked down?
New to Smart Sheet, been using it for roughly 2 months as an end user. I want to like this app and not sure if it's the app itself or if the PM has locked it down so much that it is unusable. First, I can't sort on a "% Complete" column to know what tasks are complete and which need work on (this is on a filter that the PM…
-
Any way to lock columns, but still be able to edit via Update Request?
We have an issue where users can edit certain columns in the sheet, and it has an affect on workflows, etc. We want a way to be able to lock certain columns so they can't be edited in the sheet itself. They do still need to be able to edit other columns, so we can't make them just 'viewers'. However, locking columns also…
-
I have a report in a Dashboard that doesn't show the results.
As you can see, the structure is there but it is shown as if there were no data. Yet when seing the report, there should be various entries... The viewer is not set to "its own perspective", so I don't know what I am doing wrong... Pls anybody can help ? Thanks
-
Can you format the comments in a card description? Bullets or anything? Mark up?
We are moving to Smartsheet from Trello as a company. One thing I'm missing is being able to format my description, especially missing the ability to add bullets. Just want to make sure it's not available and I'm missing somehitng!
-
Uploaded images on sheet are showing blurry
Hi there, I've created a sheet and have been uploading images from my phone via the app. All images look very sharp on the phone even when zoomed in. However, when I open the same sheet on my desktop all the images appear blurry and they export blurry too. I can't seem to locate any settings to adjust this. I've tried…
-
Restrict Date column Based on another date column
Hello Everyone, I have two columns: Entry Date and Execution Date. I am trying to restrict the Execution Date to allow only date values that are after the date of the Entry Date value. for example: For Entry date, the value is:1/1/2023 The Execution Date: should only allow dates that are after 1/1/2023. is this possible?