-
System generated Created (Date) column keeps changing itself to regular Date column.
I have a column that I'm setting to the type of Auto-Number/System that I'm setting to Created (Date). Some time later, it changes itself back to a regular Date column. I've re-set it numerous times and it keeps happening. Each time, I save and re-fresh and it stays for awhile. I've moved around and added and deleted…
-
Cross-sheet reference limitation
Hello there, I have a question about "cross-sheet reference" limitation. I receive the attached error message. I know there are limitation of number of references, however I could no find a rational for this error. I already created a sheet using a lot of references. Today I am trying to add another reference, but I…
-
Can we create a report to find which sheets have proofs attached?
We have multiple project sheets and our team uses proofs within those sheets. I want to create a report to find out which sheets have proofs attached to them. Is it possible? If not report, is there any way using formulae that we can find out if the sheet has proof? For example, if the sheet has a proof attached, a…
-
Control for Character Entry on Form
Hi there - Is there a way to control the characters used for a form? I would like to limit to just roman letters. If this isn't possible, a suggestion for a work around on the grid? ie. We have event rsvp that are entered in Chinese characters then have to translate later. Would prefer to restrict on the form itself.…
-
Month from Week Number
The data source I have is only providing WeekNumber of a transaction, e.g. 1 - 52. Is there a way to convert that week number into the respective month number, 1 - 12? I can think of a painful nested if formula or an equally painful reference table as solutions. But can anyone think of an easier formula?
-
Formula Assistance
Good Morning Community, I was hoping that someone could validate the below IFAND formula as I am getting an error which I cant resolve: =IF(Status@row = "Green", "On-track"), ifand(Status@row="Yellow", "At-risk"), ifand (Status@row="Red", "Not on track"), if(Status@row="blue", "complete")))
-
Printing Sheet Summary
Hi Is it, will it be possible to print the 'Sheet Summary' panel or export to PDF etc? Thanks Cheers Richard
-
COUNTIF Empty returns 10 extra lines
New to Smartsheet - Built a primary sheet, populated by form. 👍️ Now building a Metrics sheet to gather Status row counts to build a Database w/metric widgets. For some reason 10 extra rows are being added to my primary sheet when I use the COUNTIF formula on the Metrics sheet that references the Status column in my…
-
Automatically Advance Date Field That Is Being Used To Trigger A Workflow
I have a sheet that has a number of tasks that need to be completed on recurring schedule. Each row has a date field that I am using to trigger a workflow. In my case, the workflow is simply copying the row to another sheet when the date trigger occurs. My current shortcoming is that once that alert is triggered, I need to…
-
Timed Approval Process
I am trying to set up an Approval workflow where if the first approver didn't respond within the first 48 hours, the form needs to go to the second approver. Is there a way to do that?
