-
Date in formula
I have the following formula set to add a date to a column once information has been added to the selected columns on the same row. =IF(AND(ISBLANK([HCPCS/CPT/Supply Code]@row) = false, ISBLANK([Code Description]@row) = false, ISBLANK([Clinic Cost per Vial/ pre-filled syringe]@row) = false, ISBLANK([Vial Size]@row) =…
-
Does anyone has success story export to XML and import it to Primavera P6?
My client urged us to use Primavera P6 while our team only know to use Smartsheet. Any success story export to Microsoft Project (XML) in Smartsheet and imported it into Primavera P6? Or use indirect method convert to CSV and import it into Primavera P6?
-
Workflow Defaulting with apostrophe infront of equation
Hi Team, I have a workflow in my smart sheet that populates " '=IF([Completion Date]@row <> "", [Completion Date]@row - [Received Date]@row)" after a date change. However, the ' is not supposed to be there and is forcing me to manual change each box every time the workflow takes effect. Is there a way to fix this issue?…
-
Formula - Date Between
Hello All, I need to pull data from the sheet for the last 10 days, but the formula I used isn’t returning the correct results. Could someone review the formula and help identify what might be wrong?
-
Hot key for Expand and Collapse Row
As Business Analyst, I'm frustrated when working with large projects that I cannot expand and collapse with a hot key. I find it cumbersome to use a mouse to click the + or - on a row of nested rows to expand or collapse the nested rows. Ideally, I'd like keyboard/hotkey functionality tied to the expand and collapse…
-
Disable/Read-only Field
Would be great if we could set certain fields to disable or read-only input fields instead of just having the option to hide them.
-
SCC Performance Improvement
We have almost 2400 projects and we run global updates for a hundred or more projects multiple times per week. Sometimes we run multiple global updates per day. The UI freezes after updating about 35 projects. This forces us to manually check the projects for completion even though the process keeps running. Running global…
-
Saving A Sheet Error
Hello, A user keeps getting this error when trying to save a sheet. She is a licensed user. She's logged otu and back in a handful of times per the message below but keeps getting this message. Is there an issue with the site or is it the user's access maybe?
-
Formula Assistance for Returning a Due Date
Hello, I feel like I'm almost there on the formula, but can't figure out why WORKDAY is causing a #unparseable error. Function of the formula: If urgent flag is marked on the row I want the due date to be due on the same date that was by the 'Date Created' column type. If the flag is not marked, I want the formula to…
-
Averaging years based on name
I am trying to average the number of years old an item is per division. I have a column that is already calculating age and column for the division. I feel like this should be an easy formula but when I the following formula I get an #UNPARSEABLE error. Can someone help me figure out what I am doing wrong? The tracker…
