-
Moving rows from one sheet to another is not working
I have 2 sheets one where all the intakes are submitted to and a second one where all the complete intakes are moved to. i have an automated action that works fine. Then i notice some task were marked partially completed and they are not being moved even though they should be completed. I created a new automation action to…
-
Need Gov‑Safe Method for Detecting Resource Conflicts (Date Overlap + Name Match Failing)
I'm working in Smartsheet Gov, which has several limitations that don’t apply in commercial Smartsheet (ex: no Manage References, no HAS(), no FIND() in COLLECT, and very strict parser rules). I’m trying to build a “Calendar Conflict” flag in my Project Plan sheet that detects when: A task’s Start/End dates overlap with a…
-
Trial Version
I have used to full version of Smartsheet for many years, I have now joined a new company and downloaded the trial Smartsheet to show them how useful it would be but many functions are missing including wrap text and there is no capability to change the way the date is shown
-
URGENT - CAN'T CREATE NEW ROWS/CARDS
Hi, We wanted to report an issue we have been experiencing today with our files in Smartsheet. When trying to create new rows/cards through forms, the data did not seem to be saving — the files would load while filling out the form, but after submitting it was as if nothing had been done. After running further tests, we…
-
reset your authenticator app settings.
I lost my phone and now unable to find the authentcation code in the microsoft authenticator app. I need to reconfigure it. Please advise how to go about it.
-
IF, CONTAINS, NETDAYS, AND, CONTAINS
Hi all, Trying to use a formula to work out net days between events in a column (Visit End Date) when a second column (Visit Description) contains "V" but also only if the last visit also contains a V. =IF(CONTAINS("MV", [Monitor Visit Description]@row), NETDAYS([Monitor Visit End Date]1, [Monitor Visit End Date]2)) worked…
-
Operational issue due to new licensing restrictions - seeking ideas
Hello! I'm seeking ideas / work-arounds / the right language to convey the barriers and suggest enhancements in response to the new licensing restrictions. Here is my context. I used sheets to format a 'clinical trial transparency report card' (image below). This sheet curates institutional data from ClinicalTrials.gov…
-
Embedded images when Exporting to Excel
Is it possible to export the images that have been embedded into a sheet, when the sheet is exported to Excel. It works when exporting to PDF but not Excel.
-
Implications to prior associated data if remove a Contact from a Dropdown
Hello Community, I have a question to ask of all of you. I have a sheet with a lot of associated data to one of the 3 contact choices in my sheet. This person will be out on leave for a few months and I want to remove this person from the dropdown of choices users can select during this time. If I remove this contact now,…
-
Permanent Sort In Table View
Currently, sorting in Table View only impacts how data is displayed. It does not actually change the order of the underlying data. There are times where I rely on the data to be in a specific order (not just displayed). Lets say I have a project plan. There is a requirement that my child rows are numbered in chronological…