-
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?
-
Reminders
Does anyone else use their smartsheet app on an ipad? I'm aware and frequently use the reminder feature on a desktop, but would love help to guide my co-workers on how to use the reminder feature from an ipad while they are out in the field.
